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.PON_NEGOTIATION_COPY_GRP dependencies on FND_ATTACHED_DOCUMENTS

Line 4257: -- FND_ATTACHED_DOCUMENTS2_PKG API. But, most of the time it is NULL

4253: -- Copy Attachments for Lines if user wants to retain the attachments of the
4254: -- source document and the corresponding line in the source document has
4255: -- attachment flag on. It tried to assume that the original document should have
4256: -- the ATTACHMENT_FLAG properly set to prevent redundant calls on
4257: -- FND_ATTACHED_DOCUMENTS2_PKG API. But, most of the time it is NULL
4258: -- even if there are attachments. Hence dropping the condition as of now
4259: --
4260:
4261: /*

Line 4281: FROM FND_ATTACHED_DOCUMENTS

4277: where auction_header_id = p_source_auction_header_id;
4278:
4279: FOR base_attach_rec IN
4280: (SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE,PK2_VALUE
4281: FROM FND_ATTACHED_DOCUMENTS
4282: WHERE pk1_value = to_char(p_source_auction_header_id)
4283: AND pk2_value = to_char(l_line_number(x))
4284: AND ENTITY_NAME = 'PON_AUCTION_ITEM_PRICES_ALL'
4285: AND category_id <> (SELECT category_id FROM fnd_document_categories_vl

Line 4289: FROM FND_ATTACHED_DOCUMENTS

4285: AND category_id <> (SELECT category_id FROM fnd_document_categories_vl
4286: WHERE NAME = 'PonAmendmentSpecific')
4287: UNION
4288: SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE,PK2_VALUE
4289: FROM FND_ATTACHED_DOCUMENTS
4290: WHERE pk1_value = To_Char(l_source_prev_amend_id)
4291: AND pk2_value = to_char(l_line_number(x))
4292: AND ENTITY_NAME = 'PON_AUCTION_ITEM_PRICES_ALL'
4293: AND ATTACHED_DOCUMENT_ID NOT IN

Line 4294: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS

4290: WHERE pk1_value = To_Char(l_source_prev_amend_id)
4291: AND pk2_value = to_char(l_line_number(x))
4292: AND ENTITY_NAME = 'PON_AUCTION_ITEM_PRICES_ALL'
4293: AND ATTACHED_DOCUMENT_ID NOT IN
4294: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS
4295: WHERE pk1_value = to_char(p_source_auction_header_id))) LOOP
4296:
4297: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
4298: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

Line 4297: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

4293: AND ATTACHED_DOCUMENT_ID NOT IN
4294: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS
4295: WHERE pk1_value = to_char(p_source_auction_header_id))) LOOP
4296:
4297: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
4298: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4299: X_from_pk1_value => base_attach_rec.pk1_value,
4300: X_from_pk2_value => base_attach_rec.pk2_value,
4301: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

Line 4311: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

4307: );
4308: END LOOP;
4309:
4310: ELSE
4311: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
4312: X_from_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',
4313: X_from_pk1_value => to_char(p_source_auction_header_id),
4314: X_from_pk2_value => to_char(l_line_number(x)),
4315: X_to_entity_name => 'PON_AUCTION_ITEM_PRICES_ALL',

Line 5756: FND_ATTACHED_DOCUMENTS fnd,

5752: paps.line_number dest_line_number,
5753: paps.payment_id dest_payment_id
5754: FROM
5755: PON_AUC_PAYMENTS_SHIPMENTS paps,
5756: FND_ATTACHED_DOCUMENTS fnd,
5757: PON_AUC_PAYMENTS_SHIPMENTS psps
5758: WHERE psps.auction_header_id = p_source_auction_header_id
5759: AND paps.auction_header_id = p_auction_header_id
5760: AND paps.line_number = psps.line_number

Line 5874: FROM FND_ATTACHED_DOCUMENTS

5870: IF p_copy_type = g_conformed_doc_copy THEN
5871:
5872: FOR base_attach_rec IN
5873: (SELECT ENTITY_NAME,ATTACHED_DOCUMENT_ID,PK1_VALUE,PK2_VALUE, PK3_VALUE
5874: FROM FND_ATTACHED_DOCUMENTS
5875: WHERE pk1_value = to_char(p_source_auction_header_id)
5876: AND pk2_value = to_char(payment_line_rec.source_line_number)
5877: AND pk3_value = to_char(payment_line_rec.source_payment_id)
5878: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS'

Line 5881: FROM FND_ATTACHED_DOCUMENTS fad

5877: AND pk3_value = to_char(payment_line_rec.source_payment_id)
5878: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS'
5879: UNION
5880: SELECT ENTITY_NAME,ATTACHED_DOCUMENT_ID,PK1_VALUE,PK2_VALUE,PK3_VALUE
5881: FROM FND_ATTACHED_DOCUMENTS fad
5882: WHERE pk1_value = To_Char(p_source_auction_header_id)
5883: AND pk2_value = to_char(payment_line_rec.source_line_number)
5884: AND pk3_value = to_char(payment_line_rec.source_payment_id)
5885: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND'

Line 5887: (SELECT 1 FROM FND_ATTACHED_DOCUMENTS

5883: AND pk2_value = to_char(payment_line_rec.source_line_number)
5884: AND pk3_value = to_char(payment_line_rec.source_payment_id)
5885: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND'
5886: AND NOT EXISTS
5887: (SELECT 1 FROM FND_ATTACHED_DOCUMENTS
5888: WHERE pk1_value = to_char(p_source_auction_header_id)
5889: AND ENTITY_NAME
5890: in ('PON_AUC_PAYMENTS_SHIPMENTS',
5891: 'PON_AUC_PAYMENTS_SHIPMENTS_DEL')

Line 5894: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

5890: in ('PON_AUC_PAYMENTS_SHIPMENTS',
5891: 'PON_AUC_PAYMENTS_SHIPMENTS_DEL')
5892: AND ORIG_ATTACH_DOC_ID =fad.ORIG_ATTACH_DOC_ID)) LOOP
5893:
5894: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
5895: X_from_entity_name => base_attach_rec.ENTITY_NAME,
5896: X_from_pk1_value => base_attach_rec.pk1_value,
5897: X_from_pk2_value => base_attach_rec.pk2_value,
5898: X_from_pk3_value => base_attach_rec.pk3_value,

Line 5915: FROM FND_ATTACHED_DOCUMENTS

5911: AND Nvl(l_is_federal,0) = 1 ) THEN
5912:
5913: FOR base_attach_rec IN
5914: (SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE,PK2_VALUE, PK3_VALUE
5915: FROM FND_ATTACHED_DOCUMENTS
5916: WHERE pk1_value = to_char(payment_line_rec.source_auc_id)
5917: AND pk2_value = to_char(payment_line_rec.source_line_number)
5918: AND pk3_value = to_char(payment_line_rec.source_payment_id)
5919: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS'

Line 5922: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

5918: AND pk3_value = to_char(payment_line_rec.source_payment_id)
5919: AND ENTITY_NAME = 'PON_AUC_PAYMENTS_SHIPMENTS'
5920: ) LOOP
5921:
5922: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
5923: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
5924: X_from_pk1_value => to_char(payment_line_rec.source_auc_id),
5925: X_from_pk2_value => to_char(payment_line_rec.source_line_number),
5926: X_from_pk3_value => to_char(payment_line_rec.source_payment_id),

Line 5939: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

5935: END LOOP;
5936:
5937: ELSE
5938:
5939: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
5940: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
5941: X_from_pk1_value => to_char(payment_line_rec.source_auc_id),
5942: X_from_pk2_value => to_char(payment_line_rec.source_line_number),
5943: X_from_pk3_value => to_char(payment_line_rec.source_payment_id),

Line 11962: -- Using fnd_attached_documents2_pkg.copy_attachments

11958: IF (p_retain_attachments = 'Y' AND
11959: (l_is_federal = 0 OR p_copy_type <> g_amend_copy)) THEN
11960: --
11961: -- Copy Header and line level attachments here
11962: -- Using fnd_attached_documents2_pkg.copy_attachments
11963: -- for this purpose
11964: --
11965: -- Header Attachments copy
11966: --

Line 11978: FROM FND_ATTACHED_DOCUMENTS

11974: where auction_header_id = p_source_auction_header_id;
11975:
11976: FOR base_attach_rec IN
11977: (SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE
11978: FROM FND_ATTACHED_DOCUMENTS
11979: WHERE pk1_value = to_char(p_source_auction_header_id)
11980: AND ENTITY_NAME = 'PON_AUCTION_HEADERS_ALL'
11981: AND category_id <> (SELECT category_id FROM fnd_document_categories_vl
11982: WHERE NAME = 'PonAmendmentSpecific')

Line 11985: FROM FND_ATTACHED_DOCUMENTS

11981: AND category_id <> (SELECT category_id FROM fnd_document_categories_vl
11982: WHERE NAME = 'PonAmendmentSpecific')
11983: UNION
11984: SELECT ATTACHED_DOCUMENT_ID,PK1_VALUE
11985: FROM FND_ATTACHED_DOCUMENTS
11986: WHERE pk1_value = To_Char(l_source_orig_amend_id)
11987: AND ENTITY_NAME = 'PON_AUCTION_HEADERS_ALL'
11988: AND ATTACHED_DOCUMENT_ID NOT IN
11989: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS

Line 11989: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS

11985: FROM FND_ATTACHED_DOCUMENTS
11986: WHERE pk1_value = To_Char(l_source_orig_amend_id)
11987: AND ENTITY_NAME = 'PON_AUCTION_HEADERS_ALL'
11988: AND ATTACHED_DOCUMENT_ID NOT IN
11989: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS
11990: WHERE pk1_value = to_char(p_source_auction_header_id))) LOOP
11991:
11992: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
11993: X_from_entity_name => 'PON_AUCTION_HEADERS_ALL',

Line 11992: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

11988: AND ATTACHED_DOCUMENT_ID NOT IN
11989: (SELECT Nvl(ORIG_ATTACH_DOC_ID,-1) FROM FND_ATTACHED_DOCUMENTS
11990: WHERE pk1_value = to_char(p_source_auction_header_id))) LOOP
11991:
11992: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
11993: X_from_entity_name => 'PON_AUCTION_HEADERS_ALL',
11994: X_from_pk1_value => base_attach_rec.pk1_value,
11995: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
11996: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE

Line 12004: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

12000: );
12001: END LOOP;
12002:
12003: ELSE
12004: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
12005: X_from_entity_name => 'PON_AUCTION_HEADERS_ALL',
12006: X_from_pk1_value => to_char(p_source_auction_header_id),
12007: X_to_entity_name => 'PON_AUCTION_HEADERS_ALL',
12008: X_to_pk1_value => to_char(p_auction_header_id), -- PK1_VALUE

Line 13492: payments_orig_doc_id fnd_attached_documents.orig_attach_doc_id%TYPE;

13488: p_orig_attach_doc_id IN NUMBER,
13489: x_result OUT NOCOPY VARCHAR2
13490: )
13491: AS
13492: payments_orig_doc_id fnd_attached_documents.orig_attach_doc_id%TYPE;
13493: l_pk1_value fnd_attached_documents.pk1_value%TYPE;
13494: l_pk2_value fnd_attached_documents.pk1_value%TYPE;
13495: l_pk3_value fnd_attached_documents.pk1_value%TYPE;
13496:

Line 13493: l_pk1_value fnd_attached_documents.pk1_value%TYPE;

13489: x_result OUT NOCOPY VARCHAR2
13490: )
13491: AS
13492: payments_orig_doc_id fnd_attached_documents.orig_attach_doc_id%TYPE;
13493: l_pk1_value fnd_attached_documents.pk1_value%TYPE;
13494: l_pk2_value fnd_attached_documents.pk1_value%TYPE;
13495: l_pk3_value fnd_attached_documents.pk1_value%TYPE;
13496:
13497: BEGIN

Line 13494: l_pk2_value fnd_attached_documents.pk1_value%TYPE;

13490: )
13491: AS
13492: payments_orig_doc_id fnd_attached_documents.orig_attach_doc_id%TYPE;
13493: l_pk1_value fnd_attached_documents.pk1_value%TYPE;
13494: l_pk2_value fnd_attached_documents.pk1_value%TYPE;
13495: l_pk3_value fnd_attached_documents.pk1_value%TYPE;
13496:
13497: BEGIN
13498:

Line 13495: l_pk3_value fnd_attached_documents.pk1_value%TYPE;

13491: AS
13492: payments_orig_doc_id fnd_attached_documents.orig_attach_doc_id%TYPE;
13493: l_pk1_value fnd_attached_documents.pk1_value%TYPE;
13494: l_pk2_value fnd_attached_documents.pk1_value%TYPE;
13495: l_pk3_value fnd_attached_documents.pk1_value%TYPE;
13496:
13497: BEGIN
13498:
13499: IF p_from_entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND' THEN

Line 13501: FROM fnd_attached_documents

13497: BEGIN
13498:
13499: IF p_from_entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND' THEN
13500: SELECT orig_attach_doc_id INTO payments_orig_doc_id
13501: FROM fnd_attached_documents
13502: WHERE entity_name = 'PON_AUC_PAYMENTS_SHIPMENTS_AMEND'
13503: AND pk1_value = p_from_pk1_value
13504: AND pk2_value = p_from_pk2_value
13505: AND pk3_value = p_from_pk3_value

Line 13510: FROM fnd_attached_documents

13506: AND attached_document_id = p_orig_attach_doc_id;
13507:
13508: SELECT pk1_value, pk2_value, pk3_value
13509: INTO l_pk1_value, l_pk2_value, l_pk3_value
13510: FROM fnd_attached_documents
13511: WHERE attached_document_id = payments_orig_doc_id;
13512:
13513: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
13514: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',

Line 13513: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

13509: INTO l_pk1_value, l_pk2_value, l_pk3_value
13510: FROM fnd_attached_documents
13511: WHERE attached_document_id = payments_orig_doc_id;
13512:
13513: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
13514: X_from_entity_name => 'PON_AUC_PAYMENTS_SHIPMENTS',
13515: X_from_pk1_value => l_pk1_value,
13516: X_from_pk2_value => l_pk2_value,
13517: X_from_pk3_value => l_pk3_value,

Line 13529: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (

13525: );
13526:
13527: ELSE
13528:
13529: FND_ATTACHED_DOCUMENTS2_PKG.COPY_ATTACHMENTS (
13530: X_from_entity_name => p_from_entity_name,
13531: X_from_pk1_value => p_from_pk1_value,
13532: X_from_pk2_value => p_from_pk2_value,
13533: X_from_pk3_value => p_from_pk3_value,