DBA Data[Home] [Help]

APPS.PO_PRICE_HELPER dependencies on PO_TBL_NUMBER

Line 111: l_line_id_tbl PO_TBL_NUMBER;

107: IS
108: d_mod CONSTANT VARCHAR2(100) := D_check_system_allows_update;
109: d_position NUMBER := 0;
110:
111: l_line_id_tbl PO_TBL_NUMBER;
112: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
113: l_result_set_id NUMBER;
114: l_result_type VARCHAR2(30);
115: l_results PO_VALIDATION_RESULTS_TYPE;

Line 127: l_line_id_tbl := PO_TBL_NUMBER(p_po_line_id);

123: PO_LOG.proc_begin(d_mod, 'p_amount_changed_flag', p_amount_changed_flag); ----
124: END IF;
125:
126: d_position := 1;
127: l_line_id_tbl := PO_TBL_NUMBER(p_po_line_id);
128: l_price_break_lookup_code_tbl := PO_TBL_VARCHAR30(p_price_break_lookup_code);
129:
130: l_amount_changed_flag_tbl := PO_TBL_VARCHAR1(p_amount_changed_flag); ----
131:

Line 365: p_line_id_tbl IN PO_TBL_NUMBER

361: -- VARCHAR2(30)
362: --End of Comments
363: -------------------------------------------------------------------------------
364: PROCEDURE no_dists_reserved(
365: p_line_id_tbl IN PO_TBL_NUMBER
366: , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1
367: , x_result_set_id IN OUT NOCOPY NUMBER
368: , x_result_type OUT NOCOPY VARCHAR2)
369: IS

Line 476: p_line_id_tbl IN PO_TBL_NUMBER

472: -- VARCHAR2(30)
473: --End of Comments
474: -------------------------------------------------------------------------------
475: PROCEDURE accruals_allow_update(
476: p_line_id_tbl IN PO_TBL_NUMBER
477: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
478: , x_result_type OUT NOCOPY VARCHAR2)
479: IS
480: d_mod CONSTANT VARCHAR2(100) := D_accruals_allow_update;

Line 486: l_line_id_tbl PO_TBL_NUMBER;

482: d_stmt CONSTANT BOOLEAN := PO_LOG.d_stmt;
483:
484: l_results_count NUMBER;
485: l_data_key NUMBER;
486: l_line_id_tbl PO_TBL_NUMBER;
487: l_expense_accrual_code_tbl PO_TBL_VARCHAR4000;
488: l_header_id_tbl PO_TBL_NUMBER;
489: l_type_lookup_code_tbl PO_TBL_VARCHAR4000;
490:

Line 488: l_header_id_tbl PO_TBL_NUMBER;

484: l_results_count NUMBER;
485: l_data_key NUMBER;
486: l_line_id_tbl PO_TBL_NUMBER;
487: l_expense_accrual_code_tbl PO_TBL_VARCHAR4000;
488: l_header_id_tbl PO_TBL_NUMBER;
489: l_type_lookup_code_tbl PO_TBL_VARCHAR4000;
490:
491: l_quantity_received NUMBER;
492: l_quantity_billed NUMBER;

Line 643: p_line_id_tbl IN PO_TBL_NUMBER

639: -- VARCHAR2(30)
640: --End of Comments
641: -------------------------------------------------------------------------------
642: PROCEDURE no_timecards_exist(
643: p_line_id_tbl IN PO_TBL_NUMBER
644: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
645: , x_result_type OUT NOCOPY VARCHAR2)
646: IS
647: BEGIN

Line 687: p_line_id_tbl IN PO_TBL_NUMBER

683: -- VARCHAR2(30)
684: --End of Comments
685: -------------------------------------------------------------------------------
686: PROCEDURE no_pending_receipts(
687: p_line_id_tbl IN PO_TBL_NUMBER
688: , x_result_set_id IN OUT NOCOPY NUMBER
689: , x_result_type OUT NOCOPY VARCHAR2)
690: IS
691: d_mod CONSTANT VARCHAR2(100) := D_no_pending_receipts;

Line 781: p_line_id_tbl IN PO_TBL_NUMBER

777: -- VARCHAR2(30)
778: --End of Comments
779: -------------------------------------------------------------------------------
780: PROCEDURE retro_account_allows_update(
781: p_line_id_tbl IN PO_TBL_NUMBER
782: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
783: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
784: , x_result_type OUT NOCOPY VARCHAR2)
785: IS

Line 793: l_line_id_tbl PO_TBL_NUMBER;

789:
790: l_results_count NUMBER;
791: l_data_key NUMBER;
792:
793: l_line_id_tbl PO_TBL_NUMBER;
794: l_price_break_lookup_code_tbl PO_TBL_VARCHAR4000;
795:
796: l_line_id NUMBER;
797: l_price_break_lookup_code VARCHAR2(4000);

Line 949: p_line_id_tbl IN PO_TBL_NUMBER

945: -- VARCHAR2(30)
946: --End of Comments
947: -------------------------------------------------------------------------------
948: PROCEDURE warn_amt_based_notif_ctrls(
949: p_line_id_tbl IN PO_TBL_NUMBER
950: , x_result_set_id IN OUT NOCOPY NUMBER
951: , x_result_type OUT NOCOPY VARCHAR2)
952: IS
953: BEGIN