eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_ATTACHMENT_IMPLEMENTATION dependencies on STANDARD

Line 244: -- Standard Start of API savepoint

240: l_msg_data VARCHAR2(2000);
241: l_update_approval_status BOOLEAN;
242:
243: BEGIN
244: -- Standard Start of API savepoint
245: SAVEPOINT Update_Attachment_Status;
246:
247: -- insert into swarb values(2, 'API caller ', p_api_caller);
248: -- commit;

Line 251: -- Standard call to check for call compatibility

247: -- insert into swarb values(2, 'API caller ', p_api_caller);
248: -- commit;
249:
250: -- following temp code to test the debug messages
251: -- Standard call to check for call compatibility
252: IF NOT FND_API.Compatible_API_Call ( l_api_version
253: ,p_api_version
254: ,l_api_name
255: ,G_PKG_NAME )

Line 414: -- Standard ending code ------------------------------------------------

410:
411: -- insert into swarb values(100, 'After project call', null);
412: -- commit;
413:
414: -- Standard ending code ------------------------------------------------
415:
416: FND_MSG_PUB.Count_And_Get
417: ( p_count => x_msg_count,
418: p_data => x_msg_data );

Line 782: -- Standard Start of API savepoint

778: l_msg_data VARCHAR2(2000);
779: l_message VARCHAR2(4000);
780:
781: BEGIN
782: -- Standard Start of API savepoint
783: SAVEPOINT Implement_Attachment_Change;
784:
785: -- Standard call to check for call compatibility
786: IF NOT FND_API.Compatible_API_Call ( l_api_version

Line 785: -- Standard call to check for call compatibility

781: BEGIN
782: -- Standard Start of API savepoint
783: SAVEPOINT Implement_Attachment_Change;
784:
785: -- Standard call to check for call compatibility
786: IF NOT FND_API.Compatible_API_Call ( l_api_version
787: ,p_api_version
788: ,l_api_name
789: ,G_PKG_NAME )

Line 965: -- Standard ending code ------------------------------------------------

961:
962: end loop;
963: close C;
964:
965: -- Standard ending code ------------------------------------------------
966: FND_MSG_PUB.Count_And_Get
967: ( p_count => x_msg_count,
968: p_data => x_msg_data );
969:

Line 1066: -- Standard Start of API savepoint

1062: l_return_status VARCHAR2(1);
1063: l_msg_count NUMBER;
1064: l_msg_data VARCHAR2(2000);
1065: BEGIN
1066: -- Standard Start of API savepoint
1067: SAVEPOINT Copy_Attachment;
1068: -- Standard call to check for call compatibility
1069: IF NOT FND_API.Compatible_API_Call ( l_api_version
1070: ,p_api_version

Line 1068: -- Standard call to check for call compatibility

1064: l_msg_data VARCHAR2(2000);
1065: BEGIN
1066: -- Standard Start of API savepoint
1067: SAVEPOINT Copy_Attachment;
1068: -- Standard call to check for call compatibility
1069: IF NOT FND_API.Compatible_API_Call ( l_api_version
1070: ,p_api_version
1071: ,l_api_name
1072: ,G_PKG_NAME )

Line 1163: -- Standard ending code ------------------------------------------------

1159: update fnd_attached_documents set category_id = l_category_id, status = p_source_status where attached_document_id = l_attached_doc_id;
1160: update fnd_documents set dm_node = l_dm_node, dm_folder_path = l_dm_folder_path, dm_type = l_dm_type, dm_document_id = l_dm_document_id, dm_version_number = l_dm_version_number where document_id = l_doc_id;
1161: x_new_attachment_id := l_attached_doc_id;
1162:
1163: -- Standard ending code ------------------------------------------------
1164: FND_MSG_PUB.Count_And_Get
1165: ( p_count => x_msg_count,
1166: p_data => x_msg_data );
1167:

Line 1290: -- Standard Start of API savepoint

1286: l_return_status VARCHAR2(1);
1287: l_msg_count NUMBER;
1288: l_msg_data VARCHAR2(2000);
1289: BEGIN
1290: -- Standard Start of API savepoint
1291: SAVEPOINT Complete_Attachment_Approval;
1292: -- Standard call to check for call compatibility
1293: IF NOT FND_API.Compatible_API_Call ( l_api_version
1294: ,p_api_version

Line 1292: -- Standard call to check for call compatibility

1288: l_msg_data VARCHAR2(2000);
1289: BEGIN
1290: -- Standard Start of API savepoint
1291: SAVEPOINT Complete_Attachment_Approval;
1292: -- Standard call to check for call compatibility
1293: IF NOT FND_API.Compatible_API_Call ( l_api_version
1294: ,p_api_version
1295: ,l_api_name
1296: ,G_PKG_NAME )

Line 1341: -- Standard ending code ------------------------------------------------

1337: where attached_document_id = l_attachment_id;
1338: end loop;
1339: close C;
1340:
1341: -- Standard ending code ------------------------------------------------
1342: FND_MSG_PUB.Count_And_Get
1343: ( p_count => x_msg_count,
1344: p_data => x_msg_data );
1345:

Line 1428: -- Standard Start of API savepoint

1424: l_new_attachment_id NUMBER;
1425: l_status VARCHAR(30);
1426: l_count NUMBER;
1427: BEGIN
1428: -- Standard Start of API savepoint
1429: SAVEPOINT Copy_Attachments_And_Changes;
1430: -- Standard call to check for call compatibility
1431: IF NOT FND_API.Compatible_API_Call ( l_api_version
1432: ,p_api_version

Line 1430: -- Standard call to check for call compatibility

1426: l_count NUMBER;
1427: BEGIN
1428: -- Standard Start of API savepoint
1429: SAVEPOINT Copy_Attachments_And_Changes;
1430: -- Standard call to check for call compatibility
1431: IF NOT FND_API.Compatible_API_Call ( l_api_version
1432: ,p_api_version
1433: ,l_api_name
1434: ,G_PKG_NAME )

Line 1532: -- Standard check of p_commit.

1528: end if;
1529: end loop;
1530: close C;
1531:
1532: -- Standard check of p_commit.
1533: IF FND_API.To_Boolean( p_commit ) THEN
1534: IF g_debug_flag THEN
1535: Write_Debug('Do Commit.') ;
1536: END IF ;

Line 1539: -- Standard ending code ------------------------------------------------

1535: Write_Debug('Do Commit.') ;
1536: END IF ;
1537: COMMIT WORK;
1538: END IF;
1539: -- Standard ending code ------------------------------------------------
1540: FND_MSG_PUB.Count_And_Get
1541: ( p_count => x_msg_count,
1542: p_data => x_msg_data );
1543:

Line 1624: -- Standard Start of API savepoint

1620: l_new_attachment_id NUMBER;
1621: l_status VARCHAR(30);
1622: l_count NUMBER;
1623: BEGIN
1624: -- Standard Start of API savepoint
1625: SAVEPOINT Migrate_Attachment_And_Change;
1626: -- Standard call to check for call compatibility
1627: IF NOT FND_API.Compatible_API_Call ( l_api_version
1628: ,p_api_version

Line 1626: -- Standard call to check for call compatibility

1622: l_count NUMBER;
1623: BEGIN
1624: -- Standard Start of API savepoint
1625: SAVEPOINT Migrate_Attachment_And_Change;
1626: -- Standard call to check for call compatibility
1627: IF NOT FND_API.Compatible_API_Call ( l_api_version
1628: ,p_api_version
1629: ,l_api_name
1630: ,G_PKG_NAME )

Line 1737: -- Standard check of p_commit.

1733: and action_type = 'ATTACH'
1734: and pk3_value = p_curr_rev_id ;
1735:
1736:
1737: -- Standard check of p_commit.
1738: IF FND_API.To_Boolean( p_commit ) THEN
1739: IF g_debug_flag THEN
1740: Write_Debug('Do Commit.') ;
1741: END IF ;

Line 1744: -- Standard ending code ------------------------------------------------

1740: Write_Debug('Do Commit.') ;
1741: END IF ;
1742: COMMIT WORK;
1743: END IF;
1744: -- Standard ending code ------------------------------------------------
1745: FND_MSG_PUB.Count_And_Get
1746: ( p_count => x_msg_count,
1747: p_data => x_msg_data );
1748:

Line 1838: -- Standard Start of API savepoint

1834: l_document_id NUMBER;
1835: l_datatype_id NUMBER;
1836:
1837: BEGIN
1838: -- Standard Start of API savepoint
1839: SAVEPOINT Delete_Attachments_And_Changes;
1840: -- Standard call to check for call compatibility
1841: IF NOT FND_API.Compatible_API_Call ( l_api_version
1842: ,p_api_version

Line 1840: -- Standard call to check for call compatibility

1836:
1837: BEGIN
1838: -- Standard Start of API savepoint
1839: SAVEPOINT Delete_Attachments_And_Changes;
1840: -- Standard call to check for call compatibility
1841: IF NOT FND_API.Compatible_API_Call ( l_api_version
1842: ,p_api_version
1843: ,l_api_name
1844: ,G_PKG_NAME )

Line 1884: -- Standard ending code ------------------------------------------------

1880: close C;
1881: delete from eng_attachment_changes
1882: where change_id = p_change_id
1883: and revised_item_sequence_id = p_rev_item_seq_id;
1884: -- Standard ending code ------------------------------------------------
1885: FND_MSG_PUB.Count_And_Get
1886: ( p_count => x_msg_count,
1887: p_data => x_msg_data );
1888:

Line 1963: -- Standard Start of API savepoint

1959: l_document_exists NUMBER;
1960: BEGIN
1961: null;
1962: /*
1963: -- Standard Start of API savepoint
1964: SAVEPOINT Delete_Attachments_For_Curr_CO;
1965: -- Standard call to check for call compatibility
1966: IF NOT FND_API.Compatible_API_Call ( l_api_version
1967: ,p_api_version

Line 1965: -- Standard call to check for call compatibility

1961: null;
1962: /*
1963: -- Standard Start of API savepoint
1964: SAVEPOINT Delete_Attachments_For_Curr_CO;
1965: -- Standard call to check for call compatibility
1966: IF NOT FND_API.Compatible_API_Call ( l_api_version
1967: ,p_api_version
1968: ,l_api_name
1969: ,G_PKG_NAME )

Line 2022: -- Standard ending code ------------------------------------------------

2018: END IF;
2019: end loop;
2020: close C;
2021:
2022: -- Standard ending code ------------------------------------------------
2023: FND_MSG_PUB.Count_And_Get
2024: ( p_count => x_msg_count,
2025: p_data => x_msg_data );
2026:

Line 2101: -- Standard Start of API savepoint

2097: l_attachment_id NUMBER;
2098: l_document_id NUMBER;
2099: l_datatype_id NUMBER;
2100: BEGIN
2101: -- Standard Start of API savepoint
2102: SAVEPOINT Delete_Attachments;
2103: -- Standard call to check for call compatibility
2104: IF NOT FND_API.Compatible_API_Call ( l_api_version
2105: ,p_api_version

Line 2103: -- Standard call to check for call compatibility

2099: l_datatype_id NUMBER;
2100: BEGIN
2101: -- Standard Start of API savepoint
2102: SAVEPOINT Delete_Attachments;
2103: -- Standard call to check for call compatibility
2104: IF NOT FND_API.Compatible_API_Call ( l_api_version
2105: ,p_api_version
2106: ,l_api_name
2107: ,G_PKG_NAME )

Line 2142: -- Standard ending code ------------------------------------------------

2138: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
2139: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
2140: end loop;
2141: close C;
2142: -- Standard ending code ------------------------------------------------
2143: FND_MSG_PUB.Count_And_Get
2144: ( p_count => x_msg_count,
2145: p_data => x_msg_data );
2146:

Line 2211: -- Standard Start of API savepoint

2207: l_msg_data VARCHAR2(2000);
2208: l_document_id NUMBER;
2209: l_datatype_id NUMBER;
2210: BEGIN
2211: -- Standard Start of API savepoint
2212: SAVEPOINT Delete_Attachment;
2213: -- Standard call to check for call compatibility
2214: IF NOT FND_API.Compatible_API_Call ( l_api_version
2215: ,p_api_version

Line 2213: -- Standard call to check for call compatibility

2209: l_datatype_id NUMBER;
2210: BEGIN
2211: -- Standard Start of API savepoint
2212: SAVEPOINT Delete_Attachment;
2213: -- Standard call to check for call compatibility
2214: IF NOT FND_API.Compatible_API_Call ( l_api_version
2215: ,p_api_version
2216: ,l_api_name
2217: ,G_PKG_NAME )

Line 2254: -- Standard ending code ------------------------------------------------

2250: exception
2251: when NO_DATA_FOUND then
2252: return;
2253: end;
2254: -- Standard ending code ------------------------------------------------
2255: FND_MSG_PUB.Count_And_Get
2256: ( p_count => x_msg_count,
2257: p_data => x_msg_data );
2258:

Line 2322: -- Standard Start of API savepoint

2318: l_return_status VARCHAR2(1);
2319: l_msg_count NUMBER;
2320: l_msg_data VARCHAR2(2000);
2321: BEGIN
2322: -- Standard Start of API savepoint
2323: SAVEPOINT Delete_Changes;
2324: -- Standard call to check for call compatibility
2325: IF NOT FND_API.Compatible_API_Call ( l_api_version
2326: ,p_api_version

Line 2324: -- Standard call to check for call compatibility

2320: l_msg_data VARCHAR2(2000);
2321: BEGIN
2322: -- Standard Start of API savepoint
2323: SAVEPOINT Delete_Changes;
2324: -- Standard call to check for call compatibility
2325: IF NOT FND_API.Compatible_API_Call ( l_api_version
2326: ,p_api_version
2327: ,l_api_name
2328: ,G_PKG_NAME )

Line 2357: -- Standard ending code ------------------------------------------------

2353: -- Real code starts here -----------------------------------------------
2354: delete from eng_attachment_changes
2355: where change_id = p_change_id
2356: and revised_item_sequence_id = p_rev_item_seq_id;
2357: -- Standard ending code ------------------------------------------------
2358: FND_MSG_PUB.Count_And_Get
2359: ( p_count => x_msg_count,
2360: p_data => x_msg_data );
2361: