[Home] [Help]
35: --------------------------------------------------------------------------------
36: l_date_format VARCHAR2(20);
37: BEGIN
38:
39: l_date_format := ICX_SEC.getID( ICX_SEC.PV_DATE_FORMAT );
40: OPEN p_line_cursor FOR
41: SELECT TO_CHAR(WEB_PARAMETER_ID), -- xtype
42: TO_CHAR(AMOUNT), -- amount
43: RECEIPT_MISSING_FLAG, -- receiptmissing
1336: p_xpense_lines.rate,
1337: p_expLines.daily_amount,
1338: p_expLines.receipt_amount,
1339: sysdate,
1340: icx_sec.getID(icx_sec.PV_USER_ID), -- Bug 1733370
1341: sysdate,
1342: icx_sec.getID(icx_sec.PV_USER_ID), -- Bug 1733370
1343: i,
1344: p_expLines.amount_includes_tax,
1338: p_expLines.receipt_amount,
1339: sysdate,
1340: icx_sec.getID(icx_sec.PV_USER_ID), -- Bug 1733370
1341: sysdate,
1342: icx_sec.getID(icx_sec.PV_USER_ID), -- Bug 1733370
1343: i,
1344: p_expLines.amount_includes_tax,
1345: p_expLines.taxId,
1346: p_expLines.tax_code, -- Bug 1303470
1464: p_xpense_lines.rate,
1465: p_expLines.daily_amount,
1466: p_expLines.receipt_amount,
1467: sysdate,
1468: icx_sec.getID(icx_sec.PV_USER_ID), -- Bug 1733370
1469: sysdate,
1470: icx_sec.getID(icx_sec.PV_USER_ID), -- Bug 1733370
1471: i,
1472: p_expLines.amount_includes_tax,
1466: p_expLines.receipt_amount,
1467: sysdate,
1468: icx_sec.getID(icx_sec.PV_USER_ID), -- Bug 1733370
1469: sysdate,
1470: icx_sec.getID(icx_sec.PV_USER_ID), -- Bug 1733370
1471: i,
1472: p_expLines.amount_includes_tax,
1473: p_expLines.taxId,
1474: p_expLines.taxOverrideFlag,