APPS.CTO_UTILITY_PK dependencies on FND_ATTACHED_DOCUMENTS

Line 3967: from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_tl fdt

3963: x_return_status := fnd_api.g_ret_sts_success;
3964:
3965: -- get the file attachment locator (blob)
3966: select fl.file_data into l_blob_loc
3967: from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_tl fdt
3968: where fad.pk1_value = to_char(p_po_val_org_id)
3969: and fad.pk2_value = to_char(p_item_id)
3970: and fad.entity_name = 'MTL_SYSTEM_ITEMS'
3971: and fad.pk3_value = 'CTO:BOM:ATTACHMENT'

Line 4147: from fnd_attached_documents

4143: l_stmt := 30;
4144:
4145: select (nvl(max(seq_num),0) + 10)
4146: into l_seq_num
4147: from fnd_attached_documents
4148: where entity_name = 'MTL_SYSTEM_ITEMS'
4149: and pk1_value = to_char(p_org_id) -- 2774570
4150: and pk2_value = to_char(p_item_id); -- 6069512: Added to improve performance, we do not need seq to be unique across items.
4151:

Line 4154: select fnd_attached_documents_s.nextval

4150: and pk2_value = to_char(p_item_id); -- 6069512: Added to improve performance, we do not need seq to be unique across items.
4151:
4152:
4153: l_stmt := 40;
4154: select fnd_attached_documents_s.nextval
4155: into l_attached_document_id
4156: from dual;
4157:
4158: l_stmt := 50;

Line 4160: FND_ATTACHED_DOCUMENTS_PKG.INSERT_ROW

4156: from dual;
4157:
4158: l_stmt := 50;
4159:
4160: FND_ATTACHED_DOCUMENTS_PKG.INSERT_ROW
4161: (x_rowid => l_row_id
4162: , x_attached_document_id => l_attached_document_id
4163: , x_document_id => l_doc_id
4164: , x_seq_num => l_seq_num

Line 6676: FROM FND_ATTACHED_DOCUMENTS

6672:
6673: BEGIN
6674: SELECT document_id
6675: INTO l_document_id
6676: FROM FND_ATTACHED_DOCUMENTS
6677: WHERE pk1_value = to_char(config_orgs_rec.po_valid_org) -- 2774570
6678: AND pk2_value = to_char(config_items_rec.config_item_id) -- 2774570
6679: AND entity_name = 'MTL_SYSTEM_ITEMS'
6680: AND Pk3_value = 'CTO:BOM:ATTACHMENT';