DBA Data[Home] [Help]

APPS.PO_EXHIBITS_PVT dependencies on PO_TBL_VARCHAR1

Line 45: -- p_assigned_num_array PO_TBL_VARCHAR100 Set of line numbers for the given exhibit

41: --Function:
42: --This fucntion will return the next eligible elin (exhibit line number) for the give exhibit of that document.
43: --Parameters:
44: --IN:
45: -- p_assigned_num_array PO_TBL_VARCHAR100 Set of line numbers for the given exhibit
46: -- p_header_id Document Identifier
47: -- p_exhibit_name Exhibit name
48:
49: --IN OUT:

Line 54: FUNCTION NEXT_ELIN_NUM (p_assigned_num_array PO_TBL_VARCHAR100, p_header_id NUMBER, p_exhibit_name IN VARCHAR2) return VARCHAR2;

50: --OUT:
51: --Notes:
52: --End of Comments
53: --------------------------------------------------------------------------------
54: FUNCTION NEXT_ELIN_NUM (p_assigned_num_array PO_TBL_VARCHAR100, p_header_id NUMBER, p_exhibit_name IN VARCHAR2) return VARCHAR2;
55:
56:
57: --------------------------------------------------------------------------------
58: --Start of Comments

Line 144: p_delete_flag_tbl IN PO_TBL_VARCHAR1,

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:
148: -----------------------------------------------------------------------

Line 145: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1

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:
148: -----------------------------------------------------------------------
149: --Start of Comments

Line 214: ) RETURN PO_TBL_VARCHAR1;

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
218: --Pre-reqs: None

Line 318: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;

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:
320: --OUT:
321: --Returns:
322: --Notes:

Line 332: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,

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,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_return_msg OUT NOCOPY VARCHAR2
336:

Line 355: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;

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:
358: --Returns:
359: --Notes:

Line 368: p_is_cdrl_tbl IN PO_TBL_VARCHAR1,

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
371: );
372:

Line 389: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;

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:
391: --OUT:
392: --Returns:
393: --Notes:

Line 423: -- p_is_cdrl_tbl IN PO_TBL_VARCHAR1;

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:
425: --IN OUT:
426: --OUT:
427: --Returns: