APPS.PO_EXHIBITS_PVT dependencies on PO_TBL_NUMBER

Line 142: ( p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER,

138: --Testing:
139: --End of Comments
140: ------------------------------------------------------------------------
141: PROCEDURE sync_draft_from_txn
142: ( p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER,
143: p_draft_id_tbl IN PO_TBL_NUMBER,
144: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
145: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
146: );

Line 143: p_draft_id_tbl IN PO_TBL_NUMBER,

139: --End of Comments
140: ------------------------------------------------------------------------
141: PROCEDURE sync_draft_from_txn
142: ( p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER,
143: p_draft_id_tbl IN PO_TBL_NUMBER,
144: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
145: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
146: );
147:

Line 212: ( p_draft_id_tbl IN PO_TBL_NUMBER,

208: ( p_draft_id IN NUMBER
209: );
210:
211: FUNCTION draft_changes_exist
212: ( p_draft_id_tbl IN PO_TBL_NUMBER,
213: p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER
214: ) RETURN PO_TBL_VARCHAR1;
215: -----------------------------------------------------------------------
216: --Start of Comments

Line 213: p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER

209: );
210:
211: FUNCTION draft_changes_exist
212: ( p_draft_id_tbl IN PO_TBL_NUMBER,
213: p_po_exhibit_details_id_tbl IN PO_TBL_NUMBER
214: ) RETURN PO_TBL_VARCHAR1;
215: -----------------------------------------------------------------------
216: --Start of Comments
217: --Name: draft_changes_exist

Line 315: -- p_document_id_tbl IN PO_TBL_NUMBER;

311: -- Inserts the given exhibits for the given document if it does not exists for that document
312: --Parameters:
313: --IN:
314: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
315: -- p_document_id_tbl IN PO_TBL_NUMBER;
316: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
317: -- p_exhibit_description_tbl IN PO_TBL_VARCHAR240;
318: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
319: --IN OUT:

Line 329: p_document_id_tbl IN PO_TBL_NUMBER,

325: ------------------------------------------------------------------------
326: PROCEDURE insert_exhibits
327: (
328: p_document_type_tbl IN PO_TBL_VARCHAR30,
329: p_document_id_tbl IN PO_TBL_NUMBER,
330: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
331: p_exhibit_description_tbl IN PO_TBL_VARCHAR240,
332: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
333: p_revision_num_tbl IN PO_TBL_NUMBER,

Line 333: p_revision_num_tbl IN PO_TBL_NUMBER,

329: p_document_id_tbl IN PO_TBL_NUMBER,
330: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
331: p_exhibit_description_tbl IN PO_TBL_VARCHAR240,
332: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
333: p_revision_num_tbl IN PO_TBL_NUMBER,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_return_msg OUT NOCOPY VARCHAR2
336:
337: );

Line 353: -- p_document_id_tbl IN PO_TBL_NUMBER;

349: -- Deletes the given exhibits for the given document
350: --Parameters:
351: --IN:
352: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
353: -- p_document_id_tbl IN PO_TBL_NUMBER;
354: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
355: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
356: --IN OUT:
357: --OUT:

Line 366: p_document_id_tbl IN PO_TBL_NUMBER,

362: ------------------------------------------------------------------------
363: PROCEDURE delete_exhibits
364: (
365: p_document_type_tbl IN PO_TBL_VARCHAR30,
366: p_document_id_tbl IN PO_TBL_NUMBER,
367: p_exhibit_name_tbl IN PO_TBL_VARCHAR30,
368: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_return_msg OUT NOCOPY VARCHAR2

Line 386: -- p_document_id_tbl IN PO_TBL_NUMBER;

382: -- Copy the deliverables and exhibit for the given CDRL exhibit
383: --Parameters:
384: --IN:
385: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
386: -- p_document_id_tbl IN PO_TBL_NUMBER;
387: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
388: -- p_doc_sub_type IN VARCHAR2;
389: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
390: --IN OUT:

Line 420: -- p_document_id_tbl IN PO_TBL_NUMBER;

416: -- Delete the deliverables for the given CDRL exhibit
417: --Parameters:
418: --IN:
419: -- p_document_type_tbl IN PO_TBL_VARCHAR30;
420: -- p_document_id_tbl IN PO_TBL_NUMBER;
421: -- p_exhibit_name_tbl IN PO_TBL_VARCHAR30;
422: -- p_doc_sub_type IN VARCHAR2
423: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;
424: