APPS.PO_WAGE_DETERMINATION_ONLINE dependencies on PON_AUCTION_HEADERS_ALL

Line 167: select decode(p_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;

163: close c_get_max_attach_seq;
164:
165: l_seq_num := l_seq_num + 1;
166:
167: select decode(p_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;
168:
169: fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
170: X_attached_document_id => x_attached_document_id,
171: X_document_id => X_document_id,

Line 370: select decode(l_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;

366: close c_get_max_attach_seq;
367:
368: l_seq_num := l_seq_num + 1;
369:
370: select decode(l_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;
371:
372:
373: fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
374: X_attached_document_id => x_attached_document_id,

Line 540: FROM pon_auction_headers_all

536: IS
537:
538: CURSOR c_get_org_id IS
539: SELECT org_id
540: FROM pon_auction_headers_all
541: WHERE auction_header_id = p_auction_header_id;
542:
543: l_org_id NUMBER;
544:

Line 690: FROM pon_auction_headers_all

686: RETURN VARCHAR2
687: IS
688: CURSOR c_get_org_id IS
689: SELECT org_id
690: FROM pon_auction_headers_all
691: WHERE auction_header_id = p_document_id;
692:
693: l_org_id NUMBER;
694:

Line 704: FROM pon_auction_headers_all

700: l_enable_wdol VARCHAR2(1);
701:
702: CURSOR c_appropriate_status IS
703: SELECT 'Y'
704: FROM pon_auction_headers_all
705: WHERE Nvl(auction_status,'DRAFT') IN ('DRAFT','AUCTION_CLOSED','ACTIVE')
706: AND auction_header_id = p_document_id;
707:
708: l_app_status VARCHAR2(1):='N';