25:
26: l_lock_status number;
27: l_EI_upd_cnt number;
28:
29: l_draft_invoice_detail_id PA_PLSQL_DATATYPES.IdTabTyp;
30: l_new_draft_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp;
31: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
32: l_EI_date PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_sys_linkage PA_PLSQL_DATATYPES.Char30TabTyp; /*Bug 3857986 */
26: l_lock_status number;
27: l_EI_upd_cnt number;
28:
29: l_draft_invoice_detail_id PA_PLSQL_DATATYPES.IdTabTyp;
30: l_new_draft_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp;
31: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
32: l_EI_date PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_sys_linkage PA_PLSQL_DATATYPES.Char30TabTyp; /*Bug 3857986 */
34: l_DENOM_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
27: l_EI_upd_cnt number;
28:
29: l_draft_invoice_detail_id PA_PLSQL_DATATYPES.IdTabTyp;
30: l_new_draft_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp;
31: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
32: l_EI_date PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_sys_linkage PA_PLSQL_DATATYPES.Char30TabTyp; /*Bug 3857986 */
34: l_DENOM_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_DENOM_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
28:
29: l_draft_invoice_detail_id PA_PLSQL_DATATYPES.IdTabTyp;
30: l_new_draft_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp;
31: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
32: l_EI_date PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_sys_linkage PA_PLSQL_DATATYPES.Char30TabTyp; /*Bug 3857986 */
34: l_DENOM_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_DENOM_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
36: l_ACCT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
29: l_draft_invoice_detail_id PA_PLSQL_DATATYPES.IdTabTyp;
30: l_new_draft_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp;
31: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
32: l_EI_date PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_sys_linkage PA_PLSQL_DATATYPES.Char30TabTyp; /*Bug 3857986 */
34: l_DENOM_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_DENOM_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
36: l_ACCT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_ACCT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
30: l_new_draft_inv_detail_id PA_PLSQL_DATATYPES.IdTabTyp;
31: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
32: l_EI_date PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_sys_linkage PA_PLSQL_DATATYPES.Char30TabTyp; /*Bug 3857986 */
34: l_DENOM_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_DENOM_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
36: l_ACCT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_ACCT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_ACCT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
31: l_expenditure_item_id PA_PLSQL_DATATYPES.IdTabTyp;
32: l_EI_date PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_sys_linkage PA_PLSQL_DATATYPES.Char30TabTyp; /*Bug 3857986 */
34: l_DENOM_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_DENOM_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
36: l_ACCT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_ACCT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_ACCT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
39: l_ACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
32: l_EI_date PA_PLSQL_DATATYPES.Char30TabTyp;
33: l_sys_linkage PA_PLSQL_DATATYPES.Char30TabTyp; /*Bug 3857986 */
34: l_DENOM_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_DENOM_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
36: l_ACCT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_ACCT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_ACCT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
39: l_ACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
40: l_PROJACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
33: l_sys_linkage PA_PLSQL_DATATYPES.Char30TabTyp; /*Bug 3857986 */
34: l_DENOM_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_DENOM_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
36: l_ACCT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_ACCT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_ACCT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
39: l_ACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
40: l_PROJACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
41: l_CC_MARKUP_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
34: l_DENOM_TP_CURRENCY_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
35: l_DENOM_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
36: l_ACCT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_ACCT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_ACCT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
39: l_ACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
40: l_PROJACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
41: l_CC_MARKUP_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_TP_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
35: l_DENOM_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
36: l_ACCT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_ACCT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_ACCT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
39: l_ACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
40: l_PROJACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
41: l_CC_MARKUP_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_TP_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
43: l_TP_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
36: l_ACCT_TP_RATE_TYPE PA_PLSQL_DATATYPES.Char30TabTyp;
37: l_ACCT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_ACCT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
39: l_ACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
40: l_PROJACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
41: l_CC_MARKUP_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_TP_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
43: l_TP_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
44: l_TP_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
37: l_ACCT_TP_RATE_DATE PA_PLSQL_DATATYPES.Char30TabTyp;
38: l_ACCT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
39: l_ACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
40: l_PROJACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
41: l_CC_MARKUP_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_TP_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
43: l_TP_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
44: l_TP_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
45: l_TP_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
38: l_ACCT_TP_EXCHANGE_RATE PA_PLSQL_DATATYPES.NumTabTyp;
39: l_ACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
40: l_PROJACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
41: l_CC_MARKUP_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_TP_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
43: l_TP_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
44: l_TP_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
45: l_TP_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
46: l_TP_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
39: l_ACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
40: l_PROJACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
41: l_CC_MARKUP_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_TP_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
43: l_TP_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
44: l_TP_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
45: l_TP_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
46: l_TP_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
47: l_TP_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
40: l_PROJACCT_TRANSFER_PRICE PA_PLSQL_DATATYPES.NumTabTyp;
41: l_CC_MARKUP_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_TP_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
43: l_TP_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
44: l_TP_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
45: l_TP_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
46: l_TP_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
47: l_TP_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
48:
41: l_CC_MARKUP_BASE_CODE PA_PLSQL_DATATYPES.Char30TabTyp;
42: l_TP_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
43: l_TP_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
44: l_TP_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
45: l_TP_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
46: l_TP_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
47: l_TP_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
48:
49: l_inv_detail_rec pa_draft_invoice_details%rowtype;
42: l_TP_BASE_AMOUNT PA_PLSQL_DATATYPES.NumTabTyp;
43: l_TP_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
44: l_TP_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
45: l_TP_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
46: l_TP_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
47: l_TP_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
48:
49: l_inv_detail_rec pa_draft_invoice_details%rowtype;
50:
43: l_TP_IND_COMPILED_SET_ID PA_PLSQL_DATATYPES.IdTabTyp;
44: l_TP_BILL_RATE PA_PLSQL_DATATYPES.NumTabTyp;
45: l_TP_BILL_MARKUP_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
46: l_TP_SCHEDULE_LINE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
47: l_TP_RULE_PERCENTAGE PA_PLSQL_DATATYPES.NumTabTyp;
48:
49: l_inv_detail_rec pa_draft_invoice_details%rowtype;
50:
51: