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 1631: -- Standard Start of API savepoint

1627: l_document_id NUMBER;
1628: l_datatype_id NUMBER;
1629:
1630: BEGIN
1631: -- Standard Start of API savepoint
1632: SAVEPOINT Delete_Attachments_And_Changes;
1633: -- Standard call to check for call compatibility
1634: IF NOT FND_API.Compatible_API_Call ( l_api_version
1635: ,p_api_version

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

1629:
1630: BEGIN
1631: -- Standard Start of API savepoint
1632: SAVEPOINT Delete_Attachments_And_Changes;
1633: -- Standard call to check for call compatibility
1634: IF NOT FND_API.Compatible_API_Call ( l_api_version
1635: ,p_api_version
1636: ,l_api_name
1637: ,G_PKG_NAME )

Line 1677: -- Standard ending code ------------------------------------------------

1673: close C;
1674: delete from eng_attachment_changes
1675: where change_id = p_change_id
1676: and revised_item_sequence_id = p_rev_item_seq_id;
1677: -- Standard ending code ------------------------------------------------
1678: FND_MSG_PUB.Count_And_Get
1679: ( p_count => x_msg_count,
1680: p_data => x_msg_data );
1681:

Line 1756: -- Standard Start of API savepoint

1752: l_document_exists NUMBER;
1753: BEGIN
1754: null;
1755: /*
1756: -- Standard Start of API savepoint
1757: SAVEPOINT Delete_Attachments_For_Curr_CO;
1758: -- Standard call to check for call compatibility
1759: IF NOT FND_API.Compatible_API_Call ( l_api_version
1760: ,p_api_version

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

1754: null;
1755: /*
1756: -- Standard Start of API savepoint
1757: SAVEPOINT Delete_Attachments_For_Curr_CO;
1758: -- Standard call to check for call compatibility
1759: IF NOT FND_API.Compatible_API_Call ( l_api_version
1760: ,p_api_version
1761: ,l_api_name
1762: ,G_PKG_NAME )

Line 1815: -- Standard ending code ------------------------------------------------

1811: END IF;
1812: end loop;
1813: close C;
1814:
1815: -- Standard ending code ------------------------------------------------
1816: FND_MSG_PUB.Count_And_Get
1817: ( p_count => x_msg_count,
1818: p_data => x_msg_data );
1819:

Line 1894: -- Standard Start of API savepoint

1890: l_attachment_id NUMBER;
1891: l_document_id NUMBER;
1892: l_datatype_id NUMBER;
1893: BEGIN
1894: -- Standard Start of API savepoint
1895: SAVEPOINT Delete_Attachments;
1896: -- Standard call to check for call compatibility
1897: IF NOT FND_API.Compatible_API_Call ( l_api_version
1898: ,p_api_version

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

1892: l_datatype_id NUMBER;
1893: BEGIN
1894: -- Standard Start of API savepoint
1895: SAVEPOINT Delete_Attachments;
1896: -- Standard call to check for call compatibility
1897: IF NOT FND_API.Compatible_API_Call ( l_api_version
1898: ,p_api_version
1899: ,l_api_name
1900: ,G_PKG_NAME )

Line 1935: -- Standard ending code ------------------------------------------------

1931: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
1932: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
1933: end loop;
1934: close C;
1935: -- Standard ending code ------------------------------------------------
1936: FND_MSG_PUB.Count_And_Get
1937: ( p_count => x_msg_count,
1938: p_data => x_msg_data );
1939:

Line 2004: -- Standard Start of API savepoint

2000: l_msg_data VARCHAR2(2000);
2001: l_document_id NUMBER;
2002: l_datatype_id NUMBER;
2003: BEGIN
2004: -- Standard Start of API savepoint
2005: SAVEPOINT Delete_Attachment;
2006: -- Standard call to check for call compatibility
2007: IF NOT FND_API.Compatible_API_Call ( l_api_version
2008: ,p_api_version

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

2002: l_datatype_id NUMBER;
2003: BEGIN
2004: -- Standard Start of API savepoint
2005: SAVEPOINT Delete_Attachment;
2006: -- Standard call to check for call compatibility
2007: IF NOT FND_API.Compatible_API_Call ( l_api_version
2008: ,p_api_version
2009: ,l_api_name
2010: ,G_PKG_NAME )

Line 2047: -- Standard ending code ------------------------------------------------

2043: exception
2044: when NO_DATA_FOUND then
2045: return;
2046: end;
2047: -- Standard ending code ------------------------------------------------
2048: FND_MSG_PUB.Count_And_Get
2049: ( p_count => x_msg_count,
2050: p_data => x_msg_data );
2051:

Line 2115: -- Standard Start of API savepoint

2111: l_return_status VARCHAR2(1);
2112: l_msg_count NUMBER;
2113: l_msg_data VARCHAR2(2000);
2114: BEGIN
2115: -- Standard Start of API savepoint
2116: SAVEPOINT Delete_Changes;
2117: -- Standard call to check for call compatibility
2118: IF NOT FND_API.Compatible_API_Call ( l_api_version
2119: ,p_api_version

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

2113: l_msg_data VARCHAR2(2000);
2114: BEGIN
2115: -- Standard Start of API savepoint
2116: SAVEPOINT Delete_Changes;
2117: -- Standard call to check for call compatibility
2118: IF NOT FND_API.Compatible_API_Call ( l_api_version
2119: ,p_api_version
2120: ,l_api_name
2121: ,G_PKG_NAME )

Line 2150: -- Standard ending code ------------------------------------------------

2146: -- Real code starts here -----------------------------------------------
2147: delete from eng_attachment_changes
2148: where change_id = p_change_id
2149: and revised_item_sequence_id = p_rev_item_seq_id;
2150: -- Standard ending code ------------------------------------------------
2151: FND_MSG_PUB.Count_And_Get
2152: ( p_count => x_msg_count,
2153: p_data => x_msg_data );
2154: