eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CREDIT_MEMO_MODULE dependencies on DBMS_SQL

Line 589: p_delete_header_dist_c := dbms_sql.open_cursor;

585: ------------------------------------------------
586: BEGIN
587: debug( ' Parsing update mode stmts', MSG_LEVEL_DEBUG );
588:
589: p_delete_header_dist_c := dbms_sql.open_cursor;
590: dbms_sql.parse( p_delete_header_dist_c, l_delete_header_dist_sql,
591: dbms_sql.v7 );
592:
593: p_delete_line_dist_c := dbms_sql.open_cursor;

Line 590: dbms_sql.parse( p_delete_header_dist_c, l_delete_header_dist_sql,

586: BEGIN
587: debug( ' Parsing update mode stmts', MSG_LEVEL_DEBUG );
588:
589: p_delete_header_dist_c := dbms_sql.open_cursor;
590: dbms_sql.parse( p_delete_header_dist_c, l_delete_header_dist_sql,
591: dbms_sql.v7 );
592:
593: p_delete_line_dist_c := dbms_sql.open_cursor;
594: dbms_sql.parse( p_delete_line_dist_c, l_delete_line_dist_sql,

Line 591: dbms_sql.v7 );

587: debug( ' Parsing update mode stmts', MSG_LEVEL_DEBUG );
588:
589: p_delete_header_dist_c := dbms_sql.open_cursor;
590: dbms_sql.parse( p_delete_header_dist_c, l_delete_header_dist_sql,
591: dbms_sql.v7 );
592:
593: p_delete_line_dist_c := dbms_sql.open_cursor;
594: dbms_sql.parse( p_delete_line_dist_c, l_delete_line_dist_sql,
595: dbms_sql.v7 );

Line 593: p_delete_line_dist_c := dbms_sql.open_cursor;

589: p_delete_header_dist_c := dbms_sql.open_cursor;
590: dbms_sql.parse( p_delete_header_dist_c, l_delete_header_dist_sql,
591: dbms_sql.v7 );
592:
593: p_delete_line_dist_c := dbms_sql.open_cursor;
594: dbms_sql.parse( p_delete_line_dist_c, l_delete_line_dist_sql,
595: dbms_sql.v7 );
596:
597: p_delete_header_cma_c := dbms_sql.open_cursor;

Line 594: dbms_sql.parse( p_delete_line_dist_c, l_delete_line_dist_sql,

590: dbms_sql.parse( p_delete_header_dist_c, l_delete_header_dist_sql,
591: dbms_sql.v7 );
592:
593: p_delete_line_dist_c := dbms_sql.open_cursor;
594: dbms_sql.parse( p_delete_line_dist_c, l_delete_line_dist_sql,
595: dbms_sql.v7 );
596:
597: p_delete_header_cma_c := dbms_sql.open_cursor;
598: dbms_sql.parse( p_delete_header_cma_c, l_delete_header_cma_sql,

Line 595: dbms_sql.v7 );

591: dbms_sql.v7 );
592:
593: p_delete_line_dist_c := dbms_sql.open_cursor;
594: dbms_sql.parse( p_delete_line_dist_c, l_delete_line_dist_sql,
595: dbms_sql.v7 );
596:
597: p_delete_header_cma_c := dbms_sql.open_cursor;
598: dbms_sql.parse( p_delete_header_cma_c, l_delete_header_cma_sql,
599: dbms_sql.v7 );

Line 597: p_delete_header_cma_c := dbms_sql.open_cursor;

593: p_delete_line_dist_c := dbms_sql.open_cursor;
594: dbms_sql.parse( p_delete_line_dist_c, l_delete_line_dist_sql,
595: dbms_sql.v7 );
596:
597: p_delete_header_cma_c := dbms_sql.open_cursor;
598: dbms_sql.parse( p_delete_header_cma_c, l_delete_header_cma_sql,
599: dbms_sql.v7 );
600:
601: p_delete_line_cma_c := dbms_sql.open_cursor;

Line 598: dbms_sql.parse( p_delete_header_cma_c, l_delete_header_cma_sql,

594: dbms_sql.parse( p_delete_line_dist_c, l_delete_line_dist_sql,
595: dbms_sql.v7 );
596:
597: p_delete_header_cma_c := dbms_sql.open_cursor;
598: dbms_sql.parse( p_delete_header_cma_c, l_delete_header_cma_sql,
599: dbms_sql.v7 );
600:
601: p_delete_line_cma_c := dbms_sql.open_cursor;
602: dbms_sql.parse( p_delete_line_cma_c, l_delete_line_cma_sql,

Line 599: dbms_sql.v7 );

595: dbms_sql.v7 );
596:
597: p_delete_header_cma_c := dbms_sql.open_cursor;
598: dbms_sql.parse( p_delete_header_cma_c, l_delete_header_cma_sql,
599: dbms_sql.v7 );
600:
601: p_delete_line_cma_c := dbms_sql.open_cursor;
602: dbms_sql.parse( p_delete_line_cma_c, l_delete_line_cma_sql,
603: dbms_sql.v7 );

Line 601: p_delete_line_cma_c := dbms_sql.open_cursor;

597: p_delete_header_cma_c := dbms_sql.open_cursor;
598: dbms_sql.parse( p_delete_header_cma_c, l_delete_header_cma_sql,
599: dbms_sql.v7 );
600:
601: p_delete_line_cma_c := dbms_sql.open_cursor;
602: dbms_sql.parse( p_delete_line_cma_c, l_delete_line_cma_sql,
603: dbms_sql.v7 );
604:
605: p_update_header_lines_c := dbms_sql.open_cursor;

Line 602: dbms_sql.parse( p_delete_line_cma_c, l_delete_line_cma_sql,

598: dbms_sql.parse( p_delete_header_cma_c, l_delete_header_cma_sql,
599: dbms_sql.v7 );
600:
601: p_delete_line_cma_c := dbms_sql.open_cursor;
602: dbms_sql.parse( p_delete_line_cma_c, l_delete_line_cma_sql,
603: dbms_sql.v7 );
604:
605: p_update_header_lines_c := dbms_sql.open_cursor;
606: dbms_sql.parse( p_update_header_lines_c, l_update_header_lines_sql,

Line 603: dbms_sql.v7 );

599: dbms_sql.v7 );
600:
601: p_delete_line_cma_c := dbms_sql.open_cursor;
602: dbms_sql.parse( p_delete_line_cma_c, l_delete_line_cma_sql,
603: dbms_sql.v7 );
604:
605: p_update_header_lines_c := dbms_sql.open_cursor;
606: dbms_sql.parse( p_update_header_lines_c, l_update_header_lines_sql,
607: dbms_sql.v7 );

Line 605: p_update_header_lines_c := dbms_sql.open_cursor;

601: p_delete_line_cma_c := dbms_sql.open_cursor;
602: dbms_sql.parse( p_delete_line_cma_c, l_delete_line_cma_sql,
603: dbms_sql.v7 );
604:
605: p_update_header_lines_c := dbms_sql.open_cursor;
606: dbms_sql.parse( p_update_header_lines_c, l_update_header_lines_sql,
607: dbms_sql.v7 );
608:
609: p_update_lines_c := dbms_sql.open_cursor;

Line 606: dbms_sql.parse( p_update_header_lines_c, l_update_header_lines_sql,

602: dbms_sql.parse( p_delete_line_cma_c, l_delete_line_cma_sql,
603: dbms_sql.v7 );
604:
605: p_update_header_lines_c := dbms_sql.open_cursor;
606: dbms_sql.parse( p_update_header_lines_c, l_update_header_lines_sql,
607: dbms_sql.v7 );
608:
609: p_update_lines_c := dbms_sql.open_cursor;
610: dbms_sql.parse( p_update_lines_c, l_update_lines_sql,

Line 607: dbms_sql.v7 );

603: dbms_sql.v7 );
604:
605: p_update_header_lines_c := dbms_sql.open_cursor;
606: dbms_sql.parse( p_update_header_lines_c, l_update_header_lines_sql,
607: dbms_sql.v7 );
608:
609: p_update_lines_c := dbms_sql.open_cursor;
610: dbms_sql.parse( p_update_lines_c, l_update_lines_sql,
611: dbms_sql.v7 );

Line 609: p_update_lines_c := dbms_sql.open_cursor;

605: p_update_header_lines_c := dbms_sql.open_cursor;
606: dbms_sql.parse( p_update_header_lines_c, l_update_header_lines_sql,
607: dbms_sql.v7 );
608:
609: p_update_lines_c := dbms_sql.open_cursor;
610: dbms_sql.parse( p_update_lines_c, l_update_lines_sql,
611: dbms_sql.v7 );
612:
613: EXCEPTION

Line 610: dbms_sql.parse( p_update_lines_c, l_update_lines_sql,

606: dbms_sql.parse( p_update_header_lines_c, l_update_header_lines_sql,
607: dbms_sql.v7 );
608:
609: p_update_lines_c := dbms_sql.open_cursor;
610: dbms_sql.parse( p_update_lines_c, l_update_lines_sql,
611: dbms_sql.v7 );
612:
613: EXCEPTION
614: WHEN OTHERS THEN

Line 611: dbms_sql.v7 );

607: dbms_sql.v7 );
608:
609: p_update_lines_c := dbms_sql.open_cursor;
610: dbms_sql.parse( p_update_lines_c, l_update_lines_sql,
611: dbms_sql.v7 );
612:
613: EXCEPTION
614: WHEN OTHERS THEN
615: debug( 'EXCEPTION: Error parsing update mode stmts' );

Line 1338: p_nonrule_insert_dist_c := dbms_sql.open_cursor;

1334: ------------------------------------------------
1335: BEGIN
1336: debug( ' Parsing nonrule stmts', MSG_LEVEL_DEBUG );
1337:
1338: p_nonrule_insert_dist_c := dbms_sql.open_cursor;
1339: dbms_sql.parse( p_nonrule_insert_dist_c, l_nonrule_insert_dist_sql,
1340: dbms_sql.v7 );
1341:
1342: p_nonrule_update_lines_c := dbms_sql.open_cursor;

Line 1339: dbms_sql.parse( p_nonrule_insert_dist_c, l_nonrule_insert_dist_sql,

1335: BEGIN
1336: debug( ' Parsing nonrule stmts', MSG_LEVEL_DEBUG );
1337:
1338: p_nonrule_insert_dist_c := dbms_sql.open_cursor;
1339: dbms_sql.parse( p_nonrule_insert_dist_c, l_nonrule_insert_dist_sql,
1340: dbms_sql.v7 );
1341:
1342: p_nonrule_update_lines_c := dbms_sql.open_cursor;
1343: dbms_sql.parse( p_nonrule_update_lines_c, l_nonrule_update_lines_sql,

Line 1340: dbms_sql.v7 );

1336: debug( ' Parsing nonrule stmts', MSG_LEVEL_DEBUG );
1337:
1338: p_nonrule_insert_dist_c := dbms_sql.open_cursor;
1339: dbms_sql.parse( p_nonrule_insert_dist_c, l_nonrule_insert_dist_sql,
1340: dbms_sql.v7 );
1341:
1342: p_nonrule_update_lines_c := dbms_sql.open_cursor;
1343: dbms_sql.parse( p_nonrule_update_lines_c, l_nonrule_update_lines_sql,
1344: dbms_sql.v7 );

Line 1342: p_nonrule_update_lines_c := dbms_sql.open_cursor;

1338: p_nonrule_insert_dist_c := dbms_sql.open_cursor;
1339: dbms_sql.parse( p_nonrule_insert_dist_c, l_nonrule_insert_dist_sql,
1340: dbms_sql.v7 );
1341:
1342: p_nonrule_update_lines_c := dbms_sql.open_cursor;
1343: dbms_sql.parse( p_nonrule_update_lines_c, l_nonrule_update_lines_sql,
1344: dbms_sql.v7 );
1345:
1346: p_nonrule_update_dist_c := dbms_sql.open_cursor;

Line 1343: dbms_sql.parse( p_nonrule_update_lines_c, l_nonrule_update_lines_sql,

1339: dbms_sql.parse( p_nonrule_insert_dist_c, l_nonrule_insert_dist_sql,
1340: dbms_sql.v7 );
1341:
1342: p_nonrule_update_lines_c := dbms_sql.open_cursor;
1343: dbms_sql.parse( p_nonrule_update_lines_c, l_nonrule_update_lines_sql,
1344: dbms_sql.v7 );
1345:
1346: p_nonrule_update_dist_c := dbms_sql.open_cursor;
1347: dbms_sql.parse( p_nonrule_update_dist_c, l_nonrule_update_dist_sql,

Line 1344: dbms_sql.v7 );

1340: dbms_sql.v7 );
1341:
1342: p_nonrule_update_lines_c := dbms_sql.open_cursor;
1343: dbms_sql.parse( p_nonrule_update_lines_c, l_nonrule_update_lines_sql,
1344: dbms_sql.v7 );
1345:
1346: p_nonrule_update_dist_c := dbms_sql.open_cursor;
1347: dbms_sql.parse( p_nonrule_update_dist_c, l_nonrule_update_dist_sql,
1348: dbms_sql.v7 );

Line 1346: p_nonrule_update_dist_c := dbms_sql.open_cursor;

1342: p_nonrule_update_lines_c := dbms_sql.open_cursor;
1343: dbms_sql.parse( p_nonrule_update_lines_c, l_nonrule_update_lines_sql,
1344: dbms_sql.v7 );
1345:
1346: p_nonrule_update_dist_c := dbms_sql.open_cursor;
1347: dbms_sql.parse( p_nonrule_update_dist_c, l_nonrule_update_dist_sql,
1348: dbms_sql.v7 );
1349:
1350: p_nonrule_update_dist2_c := dbms_sql.open_cursor;

Line 1347: dbms_sql.parse( p_nonrule_update_dist_c, l_nonrule_update_dist_sql,

1343: dbms_sql.parse( p_nonrule_update_lines_c, l_nonrule_update_lines_sql,
1344: dbms_sql.v7 );
1345:
1346: p_nonrule_update_dist_c := dbms_sql.open_cursor;
1347: dbms_sql.parse( p_nonrule_update_dist_c, l_nonrule_update_dist_sql,
1348: dbms_sql.v7 );
1349:
1350: p_nonrule_update_dist2_c := dbms_sql.open_cursor;
1351: dbms_sql.parse( p_nonrule_update_dist2_c, l_nonrule_update_dist2_sql,

Line 1348: dbms_sql.v7 );

1344: dbms_sql.v7 );
1345:
1346: p_nonrule_update_dist_c := dbms_sql.open_cursor;
1347: dbms_sql.parse( p_nonrule_update_dist_c, l_nonrule_update_dist_sql,
1348: dbms_sql.v7 );
1349:
1350: p_nonrule_update_dist2_c := dbms_sql.open_cursor;
1351: dbms_sql.parse( p_nonrule_update_dist2_c, l_nonrule_update_dist2_sql,
1352: dbms_sql.v7 );

Line 1350: p_nonrule_update_dist2_c := dbms_sql.open_cursor;

1346: p_nonrule_update_dist_c := dbms_sql.open_cursor;
1347: dbms_sql.parse( p_nonrule_update_dist_c, l_nonrule_update_dist_sql,
1348: dbms_sql.v7 );
1349:
1350: p_nonrule_update_dist2_c := dbms_sql.open_cursor;
1351: dbms_sql.parse( p_nonrule_update_dist2_c, l_nonrule_update_dist2_sql,
1352: dbms_sql.v7 );
1353: EXCEPTION
1354: WHEN OTHERS THEN

Line 1351: dbms_sql.parse( p_nonrule_update_dist2_c, l_nonrule_update_dist2_sql,

1347: dbms_sql.parse( p_nonrule_update_dist_c, l_nonrule_update_dist_sql,
1348: dbms_sql.v7 );
1349:
1350: p_nonrule_update_dist2_c := dbms_sql.open_cursor;
1351: dbms_sql.parse( p_nonrule_update_dist2_c, l_nonrule_update_dist2_sql,
1352: dbms_sql.v7 );
1353: EXCEPTION
1354: WHEN OTHERS THEN
1355: debug( 'EXCEPTION: Error parsing nonrule stmts' );

Line 1352: dbms_sql.v7 );

1348: dbms_sql.v7 );
1349:
1350: p_nonrule_update_dist2_c := dbms_sql.open_cursor;
1351: dbms_sql.parse( p_nonrule_update_dist2_c, l_nonrule_update_dist2_sql,
1352: dbms_sql.v7 );
1353: EXCEPTION
1354: WHEN OTHERS THEN
1355: debug( 'EXCEPTION: Error parsing nonrule stmts' );
1356: RAISE;

Line 2050: p_rule_select_cm_lines_c := dbms_sql.open_cursor;

2046: ------------------------------------------------
2047: BEGIN
2048: debug( ' Parsing rule stmts', MSG_LEVEL_DEBUG );
2049:
2050: p_rule_select_cm_lines_c := dbms_sql.open_cursor;
2051: dbms_sql.parse( p_rule_select_cm_lines_c, l_rule_select_cm_lines_sql,
2052: dbms_sql.v7 );
2053:
2054: debug(' parsed p_rule_select_cm_lines_c');

Line 2051: dbms_sql.parse( p_rule_select_cm_lines_c, l_rule_select_cm_lines_sql,

2047: BEGIN
2048: debug( ' Parsing rule stmts', MSG_LEVEL_DEBUG );
2049:
2050: p_rule_select_cm_lines_c := dbms_sql.open_cursor;
2051: dbms_sql.parse( p_rule_select_cm_lines_c, l_rule_select_cm_lines_sql,
2052: dbms_sql.v7 );
2053:
2054: debug(' parsed p_rule_select_cm_lines_c');
2055:

Line 2052: dbms_sql.v7 );

2048: debug( ' Parsing rule stmts', MSG_LEVEL_DEBUG );
2049:
2050: p_rule_select_cm_lines_c := dbms_sql.open_cursor;
2051: dbms_sql.parse( p_rule_select_cm_lines_c, l_rule_select_cm_lines_sql,
2052: dbms_sql.v7 );
2053:
2054: debug(' parsed p_rule_select_cm_lines_c');
2055:
2056: p_rule_update_cm_lines_c := dbms_sql.open_cursor;

Line 2056: p_rule_update_cm_lines_c := dbms_sql.open_cursor;

2052: dbms_sql.v7 );
2053:
2054: debug(' parsed p_rule_select_cm_lines_c');
2055:
2056: p_rule_update_cm_lines_c := dbms_sql.open_cursor;
2057: dbms_sql.parse( p_rule_update_cm_lines_c, l_rule_update_cm_lines_sql,
2058: dbms_sql.v7 );
2059:
2060: debug(' parsed p_rule_update_cm_lines_c');

Line 2057: dbms_sql.parse( p_rule_update_cm_lines_c, l_rule_update_cm_lines_sql,

2053:
2054: debug(' parsed p_rule_select_cm_lines_c');
2055:
2056: p_rule_update_cm_lines_c := dbms_sql.open_cursor;
2057: dbms_sql.parse( p_rule_update_cm_lines_c, l_rule_update_cm_lines_sql,
2058: dbms_sql.v7 );
2059:
2060: debug(' parsed p_rule_update_cm_lines_c');
2061:

Line 2058: dbms_sql.v7 );

2054: debug(' parsed p_rule_select_cm_lines_c');
2055:
2056: p_rule_update_cm_lines_c := dbms_sql.open_cursor;
2057: dbms_sql.parse( p_rule_update_cm_lines_c, l_rule_update_cm_lines_sql,
2058: dbms_sql.v7 );
2059:
2060: debug(' parsed p_rule_update_cm_lines_c');
2061:
2062: p_rule_insert_dist_c := dbms_sql.open_cursor;

Line 2062: p_rule_insert_dist_c := dbms_sql.open_cursor;

2058: dbms_sql.v7 );
2059:
2060: debug(' parsed p_rule_update_cm_lines_c');
2061:
2062: p_rule_insert_dist_c := dbms_sql.open_cursor;
2063: dbms_sql.parse( p_rule_insert_dist_c, l_rule_insert_dist_sql,
2064: dbms_sql.v7 );
2065:
2066: debug(' parsed p_rule_insert_dist_c');

Line 2063: dbms_sql.parse( p_rule_insert_dist_c, l_rule_insert_dist_sql,

2059:
2060: debug(' parsed p_rule_update_cm_lines_c');
2061:
2062: p_rule_insert_dist_c := dbms_sql.open_cursor;
2063: dbms_sql.parse( p_rule_insert_dist_c, l_rule_insert_dist_sql,
2064: dbms_sql.v7 );
2065:
2066: debug(' parsed p_rule_insert_dist_c');
2067:

Line 2064: dbms_sql.v7 );

2060: debug(' parsed p_rule_update_cm_lines_c');
2061:
2062: p_rule_insert_dist_c := dbms_sql.open_cursor;
2063: dbms_sql.parse( p_rule_insert_dist_c, l_rule_insert_dist_sql,
2064: dbms_sql.v7 );
2065:
2066: debug(' parsed p_rule_insert_dist_c');
2067:
2068: p_rule_insert_cma_c := dbms_sql.open_cursor;

Line 2068: p_rule_insert_cma_c := dbms_sql.open_cursor;

2064: dbms_sql.v7 );
2065:
2066: debug(' parsed p_rule_insert_dist_c');
2067:
2068: p_rule_insert_cma_c := dbms_sql.open_cursor;
2069: dbms_sql.parse( p_rule_insert_cma_c, l_rule_insert_cma_sql,
2070: dbms_sql.v7 );
2071:
2072: debug(' parsed p_rule_insert_cma_c');

Line 2069: dbms_sql.parse( p_rule_insert_cma_c, l_rule_insert_cma_sql,

2065:
2066: debug(' parsed p_rule_insert_dist_c');
2067:
2068: p_rule_insert_cma_c := dbms_sql.open_cursor;
2069: dbms_sql.parse( p_rule_insert_cma_c, l_rule_insert_cma_sql,
2070: dbms_sql.v7 );
2071:
2072: debug(' parsed p_rule_insert_cma_c');
2073: EXCEPTION

Line 2070: dbms_sql.v7 );

2066: debug(' parsed p_rule_insert_dist_c');
2067:
2068: p_rule_insert_cma_c := dbms_sql.open_cursor;
2069: dbms_sql.parse( p_rule_insert_cma_c, l_rule_insert_cma_sql,
2070: dbms_sql.v7 );
2071:
2072: debug(' parsed p_rule_insert_cma_c');
2073: EXCEPTION
2074: WHEN OTHERS THEN

Line 2164: p_net_revenue_line_c := dbms_sql.open_cursor;

2160: ------------------------------------------------
2161: BEGIN
2162: debug( ' Parsing net revenue stmts', MSG_LEVEL_DEBUG );
2163:
2164: p_net_revenue_line_c := dbms_sql.open_cursor;
2165: dbms_sql.parse( p_net_revenue_line_c, l_net_revenue_line_sql,
2166: dbms_sql.v7 );
2167:
2168: EXCEPTION

Line 2165: dbms_sql.parse( p_net_revenue_line_c, l_net_revenue_line_sql,

2161: BEGIN
2162: debug( ' Parsing net revenue stmts', MSG_LEVEL_DEBUG );
2163:
2164: p_net_revenue_line_c := dbms_sql.open_cursor;
2165: dbms_sql.parse( p_net_revenue_line_c, l_net_revenue_line_sql,
2166: dbms_sql.v7 );
2167:
2168: EXCEPTION
2169: WHEN OTHERS THEN

Line 2166: dbms_sql.v7 );

2162: debug( ' Parsing net revenue stmts', MSG_LEVEL_DEBUG );
2163:
2164: p_net_revenue_line_c := dbms_sql.open_cursor;
2165: dbms_sql.parse( p_net_revenue_line_c, l_net_revenue_line_sql,
2166: dbms_sql.v7 );
2167:
2168: EXCEPTION
2169: WHEN OTHERS THEN
2170: debug( 'EXCEPTION: Error parsing net revenue stmts' );

Line 2257: dbms_sql.bind_variable( net_revenue_line_c,

2253: ---------------------------------------------------------------
2254: -- Bind variables
2255: ---------------------------------------------------------------
2256: BEGIN
2257: dbms_sql.bind_variable( net_revenue_line_c,
2258: 'start_prev_ctlid',
2259: p_prev_cust_trx_line_id );
2260: dbms_sql.bind_variable( net_revenue_line_c,
2261: 'period_set_name',

Line 2260: dbms_sql.bind_variable( net_revenue_line_c,

2256: BEGIN
2257: dbms_sql.bind_variable( net_revenue_line_c,
2258: 'start_prev_ctlid',
2259: p_prev_cust_trx_line_id );
2260: dbms_sql.bind_variable( net_revenue_line_c,
2261: 'period_set_name',
2262: system_info.period_set_name );
2263: EXCEPTION
2264: WHEN OTHERS THEN

Line 2275: l_ignore := dbms_sql.execute( net_revenue_line_c );

2271: ---------------------------------------------------------------
2272: debug( ' Executing net revenue sql', MSG_LEVEL_DEBUG );
2273:
2274: BEGIN
2275: l_ignore := dbms_sql.execute( net_revenue_line_c );
2276:
2277: EXCEPTION
2278: WHEN OTHERS THEN
2279: debug( 'EXCEPTION: Error executing net revenue sql' );

Line 2290: IF dbms_sql.fetch_rows( net_revenue_line_c ) > 0 THEN

2286: ---------------------------------------------------------------
2287: BEGIN
2288: LOOP
2289:
2290: IF dbms_sql.fetch_rows( net_revenue_line_c ) > 0 THEN
2291:
2292: debug(' Fetched a row', MSG_LEVEL_DEBUG );
2293:
2294: debug(' Load row into tables', MSG_LEVEL_DEBUG );

Line 2299: dbms_sql.column_value( net_revenue_line_c, 1,

2295:
2296: -----------------------------------------------
2297: -- Load row into table
2298: -----------------------------------------------
2299: dbms_sql.column_value( net_revenue_line_c, 1,
2300: net_rev_ctlid_t( net_rev_index ) );
2301: dbms_sql.column_value( net_revenue_line_c, 2,
2302: net_rev_gl_date_t( net_rev_index ) );
2303: dbms_sql.column_value( net_revenue_line_c, 3,

Line 2301: dbms_sql.column_value( net_revenue_line_c, 2,

2297: -- Load row into table
2298: -----------------------------------------------
2299: dbms_sql.column_value( net_revenue_line_c, 1,
2300: net_rev_ctlid_t( net_rev_index ) );
2301: dbms_sql.column_value( net_revenue_line_c, 2,
2302: net_rev_gl_date_t( net_rev_index ) );
2303: dbms_sql.column_value( net_revenue_line_c, 3,
2304: net_rev_amount_t( net_rev_index ) );
2305: dbms_sql.column_value( net_revenue_line_c, 4,

Line 2303: dbms_sql.column_value( net_revenue_line_c, 3,

2299: dbms_sql.column_value( net_revenue_line_c, 1,
2300: net_rev_ctlid_t( net_rev_index ) );
2301: dbms_sql.column_value( net_revenue_line_c, 2,
2302: net_rev_gl_date_t( net_rev_index ) );
2303: dbms_sql.column_value( net_revenue_line_c, 3,
2304: net_rev_amount_t( net_rev_index ) );
2305: dbms_sql.column_value( net_revenue_line_c, 4,
2306: net_rev_unit_t( net_rev_index ) );
2307: dbms_sql.column_value( net_revenue_line_c, 5,

Line 2305: dbms_sql.column_value( net_revenue_line_c, 4,

2301: dbms_sql.column_value( net_revenue_line_c, 2,
2302: net_rev_gl_date_t( net_rev_index ) );
2303: dbms_sql.column_value( net_revenue_line_c, 3,
2304: net_rev_amount_t( net_rev_index ) );
2305: dbms_sql.column_value( net_revenue_line_c, 4,
2306: net_rev_unit_t( net_rev_index ) );
2307: dbms_sql.column_value( net_revenue_line_c, 5,
2308: net_rev_dist_exists_t( net_rev_index ));
2309:

Line 2307: dbms_sql.column_value( net_revenue_line_c, 5,

2303: dbms_sql.column_value( net_revenue_line_c, 3,
2304: net_rev_amount_t( net_rev_index ) );
2305: dbms_sql.column_value( net_revenue_line_c, 4,
2306: net_rev_unit_t( net_rev_index ) );
2307: dbms_sql.column_value( net_revenue_line_c, 5,
2308: net_rev_dist_exists_t( net_rev_index ));
2309:
2310: net_rev_index := net_rev_index + 1;
2311:

Line 2415: dbms_sql.bind_variable( nonrule_insert_dist_c,

2411: BEGIN
2412: IF g_bind_trx_12
2413: THEN
2414: /* INSERT */
2415: dbms_sql.bind_variable( nonrule_insert_dist_c,
2416: 'cm_customer_trx_id_1',
2417: p_cm_control.customer_trx_id );
2418:
2419: dbms_sql.bind_variable( nonrule_insert_dist_c,

Line 2419: dbms_sql.bind_variable( nonrule_insert_dist_c,

2415: dbms_sql.bind_variable( nonrule_insert_dist_c,
2416: 'cm_customer_trx_id_1',
2417: p_cm_control.customer_trx_id );
2418:
2419: dbms_sql.bind_variable( nonrule_insert_dist_c,
2420: 'cm_customer_trx_id_2',
2421: p_cm_control.customer_trx_id );
2422: /* UPDATE LINE */
2423: dbms_sql.bind_variable( nonrule_update_lines_c,

Line 2423: dbms_sql.bind_variable( nonrule_update_lines_c,

2419: dbms_sql.bind_variable( nonrule_insert_dist_c,
2420: 'cm_customer_trx_id_2',
2421: p_cm_control.customer_trx_id );
2422: /* UPDATE LINE */
2423: dbms_sql.bind_variable( nonrule_update_lines_c,
2424: 'cm_customer_trx_id_1',
2425: p_cm_control.customer_trx_id );
2426:
2427: /* UPDATE DIST */

Line 2428: dbms_sql.bind_variable( nonrule_update_dist_c,

2424: 'cm_customer_trx_id_1',
2425: p_cm_control.customer_trx_id );
2426:
2427: /* UPDATE DIST */
2428: dbms_sql.bind_variable( nonrule_update_dist_c,
2429: 'cm_customer_trx_id_1',
2430: p_cm_control.customer_trx_id );
2431:
2432: END IF;

Line 2435: dbms_sql.bind_variable( nonrule_insert_dist_c,

2431:
2432: END IF;
2433: IF g_bind_trx_3
2434: THEN
2435: dbms_sql.bind_variable( nonrule_insert_dist_c,
2436: 'cm_customer_trx_id_3',
2437: p_cm_control.customer_trx_id );
2438:
2439: END IF;

Line 2447: dbms_sql.bind_variable( nonrule_update_dist2_c,

2443: RAISE;
2444: END;
2445:
2446: BEGIN
2447: dbms_sql.bind_variable( nonrule_update_dist2_c,
2448: 'cm_customer_trx_id',
2449: p_cm_control.customer_trx_id );
2450: EXCEPTION
2451: WHEN OTHERS THEN

Line 2460: dbms_sql.bind_variable( nonrule_insert_dist_c,

2456: BEGIN
2457: IF g_bind_req_12
2458: THEN
2459: /* INSERT */
2460: dbms_sql.bind_variable( nonrule_insert_dist_c,
2461: 'request_id_1',
2462: p_cm_control.request_id );
2463: dbms_sql.bind_variable( nonrule_insert_dist_c,
2464: 'request_id_2',

Line 2463: dbms_sql.bind_variable( nonrule_insert_dist_c,

2459: /* INSERT */
2460: dbms_sql.bind_variable( nonrule_insert_dist_c,
2461: 'request_id_1',
2462: p_cm_control.request_id );
2463: dbms_sql.bind_variable( nonrule_insert_dist_c,
2464: 'request_id_2',
2465: p_cm_control.request_id );
2466: /* UPDATE LINES */
2467: dbms_sql.bind_variable( nonrule_update_lines_c,

Line 2467: dbms_sql.bind_variable( nonrule_update_lines_c,

2463: dbms_sql.bind_variable( nonrule_insert_dist_c,
2464: 'request_id_2',
2465: p_cm_control.request_id );
2466: /* UPDATE LINES */
2467: dbms_sql.bind_variable( nonrule_update_lines_c,
2468: 'request_id_1',
2469: p_cm_control.request_id );
2470: /* UPDATE DISTS */
2471: dbms_sql.bind_variable( nonrule_update_dist_c,

Line 2471: dbms_sql.bind_variable( nonrule_update_dist_c,

2467: dbms_sql.bind_variable( nonrule_update_lines_c,
2468: 'request_id_1',
2469: p_cm_control.request_id );
2470: /* UPDATE DISTS */
2471: dbms_sql.bind_variable( nonrule_update_dist_c,
2472: 'request_id_1',
2473: p_cm_control.request_id );
2474:
2475: END IF;

Line 2479: dbms_sql.bind_variable( nonrule_insert_dist_c,

2475: END IF;
2476:
2477: IF g_bind_req_3
2478: THEN
2479: dbms_sql.bind_variable( nonrule_insert_dist_c,
2480: 'request_id_3',
2481: p_cm_control.request_id );
2482: END IF;
2483:

Line 2491: dbms_sql.bind_variable( nonrule_update_dist2_c,

2487: RAISE;
2488: END;
2489:
2490: BEGIN
2491: dbms_sql.bind_variable( nonrule_update_dist2_c,
2492: 'request_id',
2493: p_cm_control.request_id );
2494: EXCEPTION
2495: WHEN OTHERS THEN

Line 2507: dbms_sql.bind_variable( nonrule_insert_dist_c,

2503: BEGIN
2504: IF g_bind_line_14
2505: THEN
2506: /* INSERT */
2507: dbms_sql.bind_variable( nonrule_insert_dist_c,
2508: 'cm_cust_trx_line_id_1',
2509: p_cm_control.customer_trx_line_id );
2510: dbms_sql.bind_variable( nonrule_insert_dist_c,
2511: 'cm_cust_trx_line_id_2',

Line 2510: dbms_sql.bind_variable( nonrule_insert_dist_c,

2506: /* INSERT */
2507: dbms_sql.bind_variable( nonrule_insert_dist_c,
2508: 'cm_cust_trx_line_id_1',
2509: p_cm_control.customer_trx_line_id );
2510: dbms_sql.bind_variable( nonrule_insert_dist_c,
2511: 'cm_cust_trx_line_id_2',
2512: p_cm_control.customer_trx_line_id );
2513: dbms_sql.bind_variable( nonrule_insert_dist_c,
2514: 'cm_cust_trx_line_id_3',

Line 2513: dbms_sql.bind_variable( nonrule_insert_dist_c,

2509: p_cm_control.customer_trx_line_id );
2510: dbms_sql.bind_variable( nonrule_insert_dist_c,
2511: 'cm_cust_trx_line_id_2',
2512: p_cm_control.customer_trx_line_id );
2513: dbms_sql.bind_variable( nonrule_insert_dist_c,
2514: 'cm_cust_trx_line_id_3',
2515: p_cm_control.customer_trx_line_id );
2516: dbms_sql.bind_variable( nonrule_insert_dist_c,
2517: 'cm_cust_trx_line_id_4',

Line 2516: dbms_sql.bind_variable( nonrule_insert_dist_c,

2512: p_cm_control.customer_trx_line_id );
2513: dbms_sql.bind_variable( nonrule_insert_dist_c,
2514: 'cm_cust_trx_line_id_3',
2515: p_cm_control.customer_trx_line_id );
2516: dbms_sql.bind_variable( nonrule_insert_dist_c,
2517: 'cm_cust_trx_line_id_4',
2518: p_cm_control.customer_trx_line_id );
2519: /* UPDATE LINES */
2520: dbms_sql.bind_variable( nonrule_update_lines_c,

Line 2520: dbms_sql.bind_variable( nonrule_update_lines_c,

2516: dbms_sql.bind_variable( nonrule_insert_dist_c,
2517: 'cm_cust_trx_line_id_4',
2518: p_cm_control.customer_trx_line_id );
2519: /* UPDATE LINES */
2520: dbms_sql.bind_variable( nonrule_update_lines_c,
2521: 'cm_cust_trx_line_id_1',
2522: p_cm_control.customer_trx_line_id );
2523: dbms_sql.bind_variable( nonrule_update_lines_c,
2524: 'cm_cust_trx_line_id_2',

Line 2523: dbms_sql.bind_variable( nonrule_update_lines_c,

2519: /* UPDATE LINES */
2520: dbms_sql.bind_variable( nonrule_update_lines_c,
2521: 'cm_cust_trx_line_id_1',
2522: p_cm_control.customer_trx_line_id );
2523: dbms_sql.bind_variable( nonrule_update_lines_c,
2524: 'cm_cust_trx_line_id_2',
2525: p_cm_control.customer_trx_line_id );
2526: /* UPDATE DISTS */
2527: dbms_sql.bind_variable( nonrule_update_dist_c,

Line 2527: dbms_sql.bind_variable( nonrule_update_dist_c,

2523: dbms_sql.bind_variable( nonrule_update_lines_c,
2524: 'cm_cust_trx_line_id_2',
2525: p_cm_control.customer_trx_line_id );
2526: /* UPDATE DISTS */
2527: dbms_sql.bind_variable( nonrule_update_dist_c,
2528: 'cm_cust_trx_line_id_1',
2529: p_cm_control.customer_trx_line_id );
2530: dbms_sql.bind_variable( nonrule_update_dist_c,
2531: 'cm_cust_trx_line_id_2',

Line 2530: dbms_sql.bind_variable( nonrule_update_dist_c,

2526: /* UPDATE DISTS */
2527: dbms_sql.bind_variable( nonrule_update_dist_c,
2528: 'cm_cust_trx_line_id_1',
2529: p_cm_control.customer_trx_line_id );
2530: dbms_sql.bind_variable( nonrule_update_dist_c,
2531: 'cm_cust_trx_line_id_2',
2532: p_cm_control.customer_trx_line_id );
2533: END IF;
2534: EXCEPTION

Line 2548: l_ignore := dbms_sql.execute( nonrule_insert_dist_c );

2544: -----------------------------------------------------------------------
2545: debug( ' Inserting distributions', MSG_LEVEL_DEBUG );
2546:
2547: BEGIN
2548: l_ignore := dbms_sql.execute( nonrule_insert_dist_c );
2549: close_cursor( nonrule_insert_dist_c );
2550:
2551: debug( to_char(l_ignore) || ' row(s) inserted', MSG_LEVEL_DEBUG );
2552:

Line 2567: l_ignore := dbms_sql.execute( nonrule_update_lines_c );

2563: -----------------------------------------------------------------------
2564: debug( ' Updating lines', MSG_LEVEL_DEBUG );
2565:
2566: BEGIN
2567: l_ignore := dbms_sql.execute( nonrule_update_lines_c );
2568: close_cursor( nonrule_update_lines_c );
2569: debug( to_char(l_ignore) || ' row(s) updated', MSG_LEVEL_DEBUG );
2570:
2571: EXCEPTION

Line 2583: l_ignore := dbms_sql.execute( nonrule_update_dist_c );

2579: -----------------------------------------------------------------------
2580: debug( ' Updating distributions', MSG_LEVEL_DEBUG );
2581:
2582: BEGIN
2583: l_ignore := dbms_sql.execute( nonrule_update_dist_c );
2584: close_cursor( nonrule_update_dist_c );
2585:
2586: debug( to_char(l_ignore) || ' row(s) updated', MSG_LEVEL_DEBUG );
2587:

Line 2602: l_ignore := dbms_sql.execute( nonrule_update_dist2_c );

2598: -----------------------------------------------------------------------
2599: debug( ' Updating distributions for rounding errors', MSG_LEVEL_DEBUG );
2600:
2601: BEGIN
2602: l_ignore := dbms_sql.execute( nonrule_update_dist2_c );
2603: close_cursor( nonrule_update_dist2_c );
2604:
2605: debug( to_char(l_ignore) || ' row(s) updated', MSG_LEVEL_DEBUG );
2606:

Line 2655: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_line_id );

2651: BEGIN
2652:
2653: print_fcn_label2( 'arp_credit_memo_module.define_select_columns()+' );
2654:
2655: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_line_id );
2656: dbms_sql.define_column( p_select_c, 2,
2657: p_select_rec.prev_cust_trx_line_id );
2658: dbms_sql.define_column( p_select_c, 3,
2659: p_select_rec.allow_overapp_flag, 1 );

Line 2656: dbms_sql.define_column( p_select_c, 2,

2652:
2653: print_fcn_label2( 'arp_credit_memo_module.define_select_columns()+' );
2654:
2655: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_line_id );
2656: dbms_sql.define_column( p_select_c, 2,
2657: p_select_rec.prev_cust_trx_line_id );
2658: dbms_sql.define_column( p_select_c, 3,
2659: p_select_rec.allow_overapp_flag, 1 );
2660: dbms_sql.define_column( p_select_c, 4, p_select_rec.cm_amount );

Line 2658: dbms_sql.define_column( p_select_c, 3,

2654:
2655: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_line_id );
2656: dbms_sql.define_column( p_select_c, 2,
2657: p_select_rec.prev_cust_trx_line_id );
2658: dbms_sql.define_column( p_select_c, 3,
2659: p_select_rec.allow_overapp_flag, 1 );
2660: dbms_sql.define_column( p_select_c, 4, p_select_rec.cm_amount );
2661: dbms_sql.define_column( p_select_c, 5,
2662: p_select_rec.credit_method_for_rules, 1 );

Line 2660: dbms_sql.define_column( p_select_c, 4, p_select_rec.cm_amount );

2656: dbms_sql.define_column( p_select_c, 2,
2657: p_select_rec.prev_cust_trx_line_id );
2658: dbms_sql.define_column( p_select_c, 3,
2659: p_select_rec.allow_overapp_flag, 1 );
2660: dbms_sql.define_column( p_select_c, 4, p_select_rec.cm_amount );
2661: dbms_sql.define_column( p_select_c, 5,
2662: p_select_rec.credit_method_for_rules, 1 );
2663: dbms_sql.define_column( p_select_c, 6,
2664: p_select_rec.last_period_to_credit );

Line 2661: dbms_sql.define_column( p_select_c, 5,

2657: p_select_rec.prev_cust_trx_line_id );
2658: dbms_sql.define_column( p_select_c, 3,
2659: p_select_rec.allow_overapp_flag, 1 );
2660: dbms_sql.define_column( p_select_c, 4, p_select_rec.cm_amount );
2661: dbms_sql.define_column( p_select_c, 5,
2662: p_select_rec.credit_method_for_rules, 1 );
2663: dbms_sql.define_column( p_select_c, 6,
2664: p_select_rec.last_period_to_credit );
2665: dbms_sql.define_column( p_select_c, 7, p_select_rec.currency_code, 15 );

Line 2663: dbms_sql.define_column( p_select_c, 6,

2659: p_select_rec.allow_overapp_flag, 1 );
2660: dbms_sql.define_column( p_select_c, 4, p_select_rec.cm_amount );
2661: dbms_sql.define_column( p_select_c, 5,
2662: p_select_rec.credit_method_for_rules, 1 );
2663: dbms_sql.define_column( p_select_c, 6,
2664: p_select_rec.last_period_to_credit );
2665: dbms_sql.define_column( p_select_c, 7, p_select_rec.currency_code, 15 );
2666: dbms_sql.define_column( p_select_c, 8,
2667: p_select_rec.inv_acct_rule_duration );

Line 2665: dbms_sql.define_column( p_select_c, 7, p_select_rec.currency_code, 15 );

2661: dbms_sql.define_column( p_select_c, 5,
2662: p_select_rec.credit_method_for_rules, 1 );
2663: dbms_sql.define_column( p_select_c, 6,
2664: p_select_rec.last_period_to_credit );
2665: dbms_sql.define_column( p_select_c, 7, p_select_rec.currency_code, 15 );
2666: dbms_sql.define_column( p_select_c, 8,
2667: p_select_rec.inv_acct_rule_duration );
2668: dbms_sql.define_column( p_select_c, 9,
2669: p_select_rec.allow_not_open_flag, 1 );

Line 2666: dbms_sql.define_column( p_select_c, 8,

2662: p_select_rec.credit_method_for_rules, 1 );
2663: dbms_sql.define_column( p_select_c, 6,
2664: p_select_rec.last_period_to_credit );
2665: dbms_sql.define_column( p_select_c, 7, p_select_rec.currency_code, 15 );
2666: dbms_sql.define_column( p_select_c, 8,
2667: p_select_rec.inv_acct_rule_duration );
2668: dbms_sql.define_column( p_select_c, 9,
2669: p_select_rec.allow_not_open_flag, 1 );
2670: dbms_sql.define_column( p_select_c, 10, p_select_rec.cm_gl_date );

Line 2668: dbms_sql.define_column( p_select_c, 9,

2664: p_select_rec.last_period_to_credit );
2665: dbms_sql.define_column( p_select_c, 7, p_select_rec.currency_code, 15 );
2666: dbms_sql.define_column( p_select_c, 8,
2667: p_select_rec.inv_acct_rule_duration );
2668: dbms_sql.define_column( p_select_c, 9,
2669: p_select_rec.allow_not_open_flag, 1 );
2670: dbms_sql.define_column( p_select_c, 10, p_select_rec.cm_gl_date );
2671: dbms_sql.define_column( p_select_c, 11, p_select_rec.invoice_quantity );
2672: dbms_sql.define_column( p_select_c, 12,

Line 2670: dbms_sql.define_column( p_select_c, 10, p_select_rec.cm_gl_date );

2666: dbms_sql.define_column( p_select_c, 8,
2667: p_select_rec.inv_acct_rule_duration );
2668: dbms_sql.define_column( p_select_c, 9,
2669: p_select_rec.allow_not_open_flag, 1 );
2670: dbms_sql.define_column( p_select_c, 10, p_select_rec.cm_gl_date );
2671: dbms_sql.define_column( p_select_c, 11, p_select_rec.invoice_quantity );
2672: dbms_sql.define_column( p_select_c, 12,
2673: p_select_rec.cm_quantity );
2674: dbms_sql.define_column( p_select_c, 13,

Line 2671: dbms_sql.define_column( p_select_c, 11, p_select_rec.invoice_quantity );

2667: p_select_rec.inv_acct_rule_duration );
2668: dbms_sql.define_column( p_select_c, 9,
2669: p_select_rec.allow_not_open_flag, 1 );
2670: dbms_sql.define_column( p_select_c, 10, p_select_rec.cm_gl_date );
2671: dbms_sql.define_column( p_select_c, 11, p_select_rec.invoice_quantity );
2672: dbms_sql.define_column( p_select_c, 12,
2673: p_select_rec.cm_quantity );
2674: dbms_sql.define_column( p_select_c, 13,
2675: p_select_rec.invoice_sign);

Line 2672: dbms_sql.define_column( p_select_c, 12,

2668: dbms_sql.define_column( p_select_c, 9,
2669: p_select_rec.allow_not_open_flag, 1 );
2670: dbms_sql.define_column( p_select_c, 10, p_select_rec.cm_gl_date );
2671: dbms_sql.define_column( p_select_c, 11, p_select_rec.invoice_quantity );
2672: dbms_sql.define_column( p_select_c, 12,
2673: p_select_rec.cm_quantity );
2674: dbms_sql.define_column( p_select_c, 13,
2675: p_select_rec.invoice_sign);
2676: dbms_sql.define_column( p_select_c, 14, p_select_rec.cm_sign);

Line 2674: dbms_sql.define_column( p_select_c, 13,

2670: dbms_sql.define_column( p_select_c, 10, p_select_rec.cm_gl_date );
2671: dbms_sql.define_column( p_select_c, 11, p_select_rec.invoice_quantity );
2672: dbms_sql.define_column( p_select_c, 12,
2673: p_select_rec.cm_quantity );
2674: dbms_sql.define_column( p_select_c, 13,
2675: p_select_rec.invoice_sign);
2676: dbms_sql.define_column( p_select_c, 14, p_select_rec.cm_sign);
2677: dbms_sql.define_column( p_select_c, 15, p_select_rec.partial_period_flag,1);
2678: /* 4621029 */

Line 2676: dbms_sql.define_column( p_select_c, 14, p_select_rec.cm_sign);

2672: dbms_sql.define_column( p_select_c, 12,
2673: p_select_rec.cm_quantity );
2674: dbms_sql.define_column( p_select_c, 13,
2675: p_select_rec.invoice_sign);
2676: dbms_sql.define_column( p_select_c, 14, p_select_rec.cm_sign);
2677: dbms_sql.define_column( p_select_c, 15, p_select_rec.partial_period_flag,1);
2678: /* 4621029 */
2679: dbms_sql.define_column( p_select_c, 16, p_select_rec.inv_unit_price);
2680: dbms_sql.define_column( p_select_c, 17, p_select_rec.cm_unit_price);

Line 2677: dbms_sql.define_column( p_select_c, 15, p_select_rec.partial_period_flag,1);

2673: p_select_rec.cm_quantity );
2674: dbms_sql.define_column( p_select_c, 13,
2675: p_select_rec.invoice_sign);
2676: dbms_sql.define_column( p_select_c, 14, p_select_rec.cm_sign);
2677: dbms_sql.define_column( p_select_c, 15, p_select_rec.partial_period_flag,1);
2678: /* 4621029 */
2679: dbms_sql.define_column( p_select_c, 16, p_select_rec.inv_unit_price);
2680: dbms_sql.define_column( p_select_c, 17, p_select_rec.cm_unit_price);
2681: /* 4621029 end */

Line 2679: dbms_sql.define_column( p_select_c, 16, p_select_rec.inv_unit_price);

2675: p_select_rec.invoice_sign);
2676: dbms_sql.define_column( p_select_c, 14, p_select_rec.cm_sign);
2677: dbms_sql.define_column( p_select_c, 15, p_select_rec.partial_period_flag,1);
2678: /* 4621029 */
2679: dbms_sql.define_column( p_select_c, 16, p_select_rec.inv_unit_price);
2680: dbms_sql.define_column( p_select_c, 17, p_select_rec.cm_unit_price);
2681: /* 4621029 end */
2682:
2683: print_fcn_label2( 'arp_credit_memo_module.define_select_columns()-' );

Line 2680: dbms_sql.define_column( p_select_c, 17, p_select_rec.cm_unit_price);

2676: dbms_sql.define_column( p_select_c, 14, p_select_rec.cm_sign);
2677: dbms_sql.define_column( p_select_c, 15, p_select_rec.partial_period_flag,1);
2678: /* 4621029 */
2679: dbms_sql.define_column( p_select_c, 16, p_select_rec.inv_unit_price);
2680: dbms_sql.define_column( p_select_c, 17, p_select_rec.cm_unit_price);
2681: /* 4621029 end */
2682:
2683: print_fcn_label2( 'arp_credit_memo_module.define_select_columns()-' );
2684:

Line 2720: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_line_id );

2716: BEGIN
2717:
2718: print_fcn_label2( 'arp_credit_memo_module.get_select_column_values()+' );
2719:
2720: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_line_id );
2721: dbms_sql.column_value( p_select_c, 2, p_select_rec.prev_cust_trx_line_id );
2722: dbms_sql.column_value( p_select_c, 3,
2723: p_select_rec.allow_overapp_flag );
2724: dbms_sql.column_value( p_select_c, 4, p_select_rec.cm_amount );

Line 2721: dbms_sql.column_value( p_select_c, 2, p_select_rec.prev_cust_trx_line_id );

2717:
2718: print_fcn_label2( 'arp_credit_memo_module.get_select_column_values()+' );
2719:
2720: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_line_id );
2721: dbms_sql.column_value( p_select_c, 2, p_select_rec.prev_cust_trx_line_id );
2722: dbms_sql.column_value( p_select_c, 3,
2723: p_select_rec.allow_overapp_flag );
2724: dbms_sql.column_value( p_select_c, 4, p_select_rec.cm_amount );
2725: dbms_sql.column_value( p_select_c, 5,

Line 2722: dbms_sql.column_value( p_select_c, 3,

2718: print_fcn_label2( 'arp_credit_memo_module.get_select_column_values()+' );
2719:
2720: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_line_id );
2721: dbms_sql.column_value( p_select_c, 2, p_select_rec.prev_cust_trx_line_id );
2722: dbms_sql.column_value( p_select_c, 3,
2723: p_select_rec.allow_overapp_flag );
2724: dbms_sql.column_value( p_select_c, 4, p_select_rec.cm_amount );
2725: dbms_sql.column_value( p_select_c, 5,
2726: p_select_rec.credit_method_for_rules );

Line 2724: dbms_sql.column_value( p_select_c, 4, p_select_rec.cm_amount );

2720: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_line_id );
2721: dbms_sql.column_value( p_select_c, 2, p_select_rec.prev_cust_trx_line_id );
2722: dbms_sql.column_value( p_select_c, 3,
2723: p_select_rec.allow_overapp_flag );
2724: dbms_sql.column_value( p_select_c, 4, p_select_rec.cm_amount );
2725: dbms_sql.column_value( p_select_c, 5,
2726: p_select_rec.credit_method_for_rules );
2727: dbms_sql.column_value( p_select_c, 6, p_select_rec.last_period_to_credit );
2728: dbms_sql.column_value( p_select_c, 7, p_select_rec.currency_code );

Line 2725: dbms_sql.column_value( p_select_c, 5,

2721: dbms_sql.column_value( p_select_c, 2, p_select_rec.prev_cust_trx_line_id );
2722: dbms_sql.column_value( p_select_c, 3,
2723: p_select_rec.allow_overapp_flag );
2724: dbms_sql.column_value( p_select_c, 4, p_select_rec.cm_amount );
2725: dbms_sql.column_value( p_select_c, 5,
2726: p_select_rec.credit_method_for_rules );
2727: dbms_sql.column_value( p_select_c, 6, p_select_rec.last_period_to_credit );
2728: dbms_sql.column_value( p_select_c, 7, p_select_rec.currency_code );
2729: dbms_sql.column_value( p_select_c, 8,

Line 2727: dbms_sql.column_value( p_select_c, 6, p_select_rec.last_period_to_credit );

2723: p_select_rec.allow_overapp_flag );
2724: dbms_sql.column_value( p_select_c, 4, p_select_rec.cm_amount );
2725: dbms_sql.column_value( p_select_c, 5,
2726: p_select_rec.credit_method_for_rules );
2727: dbms_sql.column_value( p_select_c, 6, p_select_rec.last_period_to_credit );
2728: dbms_sql.column_value( p_select_c, 7, p_select_rec.currency_code );
2729: dbms_sql.column_value( p_select_c, 8,
2730: p_select_rec.inv_acct_rule_duration );
2731: dbms_sql.column_value( p_select_c, 9, p_select_rec.allow_not_open_flag );

Line 2728: dbms_sql.column_value( p_select_c, 7, p_select_rec.currency_code );

2724: dbms_sql.column_value( p_select_c, 4, p_select_rec.cm_amount );
2725: dbms_sql.column_value( p_select_c, 5,
2726: p_select_rec.credit_method_for_rules );
2727: dbms_sql.column_value( p_select_c, 6, p_select_rec.last_period_to_credit );
2728: dbms_sql.column_value( p_select_c, 7, p_select_rec.currency_code );
2729: dbms_sql.column_value( p_select_c, 8,
2730: p_select_rec.inv_acct_rule_duration );
2731: dbms_sql.column_value( p_select_c, 9, p_select_rec.allow_not_open_flag );
2732: dbms_sql.column_value( p_select_c, 10, p_select_rec.cm_gl_date );

Line 2729: dbms_sql.column_value( p_select_c, 8,

2725: dbms_sql.column_value( p_select_c, 5,
2726: p_select_rec.credit_method_for_rules );
2727: dbms_sql.column_value( p_select_c, 6, p_select_rec.last_period_to_credit );
2728: dbms_sql.column_value( p_select_c, 7, p_select_rec.currency_code );
2729: dbms_sql.column_value( p_select_c, 8,
2730: p_select_rec.inv_acct_rule_duration );
2731: dbms_sql.column_value( p_select_c, 9, p_select_rec.allow_not_open_flag );
2732: dbms_sql.column_value( p_select_c, 10, p_select_rec.cm_gl_date );
2733: dbms_sql.column_value( p_select_c, 11, p_select_rec.invoice_quantity );

Line 2731: dbms_sql.column_value( p_select_c, 9, p_select_rec.allow_not_open_flag );

2727: dbms_sql.column_value( p_select_c, 6, p_select_rec.last_period_to_credit );
2728: dbms_sql.column_value( p_select_c, 7, p_select_rec.currency_code );
2729: dbms_sql.column_value( p_select_c, 8,
2730: p_select_rec.inv_acct_rule_duration );
2731: dbms_sql.column_value( p_select_c, 9, p_select_rec.allow_not_open_flag );
2732: dbms_sql.column_value( p_select_c, 10, p_select_rec.cm_gl_date );
2733: dbms_sql.column_value( p_select_c, 11, p_select_rec.invoice_quantity );
2734: dbms_sql.column_value( p_select_c, 12,
2735: p_select_rec.cm_quantity );

Line 2732: dbms_sql.column_value( p_select_c, 10, p_select_rec.cm_gl_date );

2728: dbms_sql.column_value( p_select_c, 7, p_select_rec.currency_code );
2729: dbms_sql.column_value( p_select_c, 8,
2730: p_select_rec.inv_acct_rule_duration );
2731: dbms_sql.column_value( p_select_c, 9, p_select_rec.allow_not_open_flag );
2732: dbms_sql.column_value( p_select_c, 10, p_select_rec.cm_gl_date );
2733: dbms_sql.column_value( p_select_c, 11, p_select_rec.invoice_quantity );
2734: dbms_sql.column_value( p_select_c, 12,
2735: p_select_rec.cm_quantity );
2736: dbms_sql.column_value( p_select_c, 13,

Line 2733: dbms_sql.column_value( p_select_c, 11, p_select_rec.invoice_quantity );

2729: dbms_sql.column_value( p_select_c, 8,
2730: p_select_rec.inv_acct_rule_duration );
2731: dbms_sql.column_value( p_select_c, 9, p_select_rec.allow_not_open_flag );
2732: dbms_sql.column_value( p_select_c, 10, p_select_rec.cm_gl_date );
2733: dbms_sql.column_value( p_select_c, 11, p_select_rec.invoice_quantity );
2734: dbms_sql.column_value( p_select_c, 12,
2735: p_select_rec.cm_quantity );
2736: dbms_sql.column_value( p_select_c, 13,
2737: p_select_rec.invoice_sign );

Line 2734: dbms_sql.column_value( p_select_c, 12,

2730: p_select_rec.inv_acct_rule_duration );
2731: dbms_sql.column_value( p_select_c, 9, p_select_rec.allow_not_open_flag );
2732: dbms_sql.column_value( p_select_c, 10, p_select_rec.cm_gl_date );
2733: dbms_sql.column_value( p_select_c, 11, p_select_rec.invoice_quantity );
2734: dbms_sql.column_value( p_select_c, 12,
2735: p_select_rec.cm_quantity );
2736: dbms_sql.column_value( p_select_c, 13,
2737: p_select_rec.invoice_sign );
2738: dbms_sql.column_value( p_select_c, 14, p_select_rec.cm_sign );

Line 2736: dbms_sql.column_value( p_select_c, 13,

2732: dbms_sql.column_value( p_select_c, 10, p_select_rec.cm_gl_date );
2733: dbms_sql.column_value( p_select_c, 11, p_select_rec.invoice_quantity );
2734: dbms_sql.column_value( p_select_c, 12,
2735: p_select_rec.cm_quantity );
2736: dbms_sql.column_value( p_select_c, 13,
2737: p_select_rec.invoice_sign );
2738: dbms_sql.column_value( p_select_c, 14, p_select_rec.cm_sign );
2739: dbms_sql.column_value( p_select_c, 15, p_select_rec.partial_period_flag);
2740: /* 4621029 */

Line 2738: dbms_sql.column_value( p_select_c, 14, p_select_rec.cm_sign );

2734: dbms_sql.column_value( p_select_c, 12,
2735: p_select_rec.cm_quantity );
2736: dbms_sql.column_value( p_select_c, 13,
2737: p_select_rec.invoice_sign );
2738: dbms_sql.column_value( p_select_c, 14, p_select_rec.cm_sign );
2739: dbms_sql.column_value( p_select_c, 15, p_select_rec.partial_period_flag);
2740: /* 4621029 */
2741: dbms_sql.column_value( p_select_c, 16, p_select_rec.inv_unit_price);
2742: dbms_sql.column_value( p_select_c, 17, p_select_rec.cm_unit_price);

Line 2739: dbms_sql.column_value( p_select_c, 15, p_select_rec.partial_period_flag);

2735: p_select_rec.cm_quantity );
2736: dbms_sql.column_value( p_select_c, 13,
2737: p_select_rec.invoice_sign );
2738: dbms_sql.column_value( p_select_c, 14, p_select_rec.cm_sign );
2739: dbms_sql.column_value( p_select_c, 15, p_select_rec.partial_period_flag);
2740: /* 4621029 */
2741: dbms_sql.column_value( p_select_c, 16, p_select_rec.inv_unit_price);
2742: dbms_sql.column_value( p_select_c, 17, p_select_rec.cm_unit_price);
2743: /* 4621029 end */

Line 2741: dbms_sql.column_value( p_select_c, 16, p_select_rec.inv_unit_price);

2737: p_select_rec.invoice_sign );
2738: dbms_sql.column_value( p_select_c, 14, p_select_rec.cm_sign );
2739: dbms_sql.column_value( p_select_c, 15, p_select_rec.partial_period_flag);
2740: /* 4621029 */
2741: dbms_sql.column_value( p_select_c, 16, p_select_rec.inv_unit_price);
2742: dbms_sql.column_value( p_select_c, 17, p_select_rec.cm_unit_price);
2743: /* 4621029 end */
2744:
2745:

Line 2742: dbms_sql.column_value( p_select_c, 17, p_select_rec.cm_unit_price);

2738: dbms_sql.column_value( p_select_c, 14, p_select_rec.cm_sign );
2739: dbms_sql.column_value( p_select_c, 15, p_select_rec.partial_period_flag);
2740: /* 4621029 */
2741: dbms_sql.column_value( p_select_c, 16, p_select_rec.inv_unit_price);
2742: dbms_sql.column_value( p_select_c, 17, p_select_rec.cm_unit_price);
2743: /* 4621029 end */
2744:
2745:
2746: print_fcn_label2( 'arp_credit_memo_module.get_select_column_values()-' );

Line 2958: dbms_sql.bind_variable( rule_insert_dist_c,

2954: -------------------------------------------------------------
2955: BEGIN
2956: debug( ' Binding rule_insert_dist_c', MSG_LEVEL_DEBUG );
2957:
2958: dbms_sql.bind_variable( rule_insert_dist_c,
2959: 'customer_trx_line_id',
2960: cm_sched_ctlid_t( i ) );
2961: /*7147479 added binding for customer_trx_line_id_1*/
2962: dbms_sql.bind_variable( rule_insert_dist_c,

Line 2962: dbms_sql.bind_variable( rule_insert_dist_c,

2958: dbms_sql.bind_variable( rule_insert_dist_c,
2959: 'customer_trx_line_id',
2960: cm_sched_ctlid_t( i ) );
2961: /*7147479 added binding for customer_trx_line_id_1*/
2962: dbms_sql.bind_variable( rule_insert_dist_c,
2963: 'customer_trx_line_id_1',
2964: cm_sched_ctlid_t( i ) );
2965: dbms_sql.bind_variable( rule_insert_dist_c,
2966: 'gl_date',

Line 2965: dbms_sql.bind_variable( rule_insert_dist_c,

2961: /*7147479 added binding for customer_trx_line_id_1*/
2962: dbms_sql.bind_variable( rule_insert_dist_c,
2963: 'customer_trx_line_id_1',
2964: cm_sched_ctlid_t( i ) );
2965: dbms_sql.bind_variable( rule_insert_dist_c,
2966: 'gl_date',
2967: cm_sched_gl_date_t( i ) );
2968: dbms_sql.bind_variable( rule_insert_dist_c,
2969: 'amount',

Line 2968: dbms_sql.bind_variable( rule_insert_dist_c,

2964: cm_sched_ctlid_t( i ) );
2965: dbms_sql.bind_variable( rule_insert_dist_c,
2966: 'gl_date',
2967: cm_sched_gl_date_t( i ) );
2968: dbms_sql.bind_variable( rule_insert_dist_c,
2969: 'amount',
2970: cm_sched_amount_t( i ) );
2971: dbms_sql.bind_variable( rule_insert_dist_c,
2972: 'amount_1',

Line 2971: dbms_sql.bind_variable( rule_insert_dist_c,

2967: cm_sched_gl_date_t( i ) );
2968: dbms_sql.bind_variable( rule_insert_dist_c,
2969: 'amount',
2970: cm_sched_amount_t( i ) );
2971: dbms_sql.bind_variable( rule_insert_dist_c,
2972: 'amount_1',
2973: cm_sched_amount_t( i ) );
2974: dbms_sql.bind_variable( rule_insert_dist_c,
2975: 'amount_2',

Line 2974: dbms_sql.bind_variable( rule_insert_dist_c,

2970: cm_sched_amount_t( i ) );
2971: dbms_sql.bind_variable( rule_insert_dist_c,
2972: 'amount_1',
2973: cm_sched_amount_t( i ) );
2974: dbms_sql.bind_variable( rule_insert_dist_c,
2975: 'amount_2',
2976: cm_sched_amount_t( i ) );
2977: dbms_sql.bind_variable( rule_insert_dist_c,
2978: 'amount_3',

Line 2977: dbms_sql.bind_variable( rule_insert_dist_c,

2973: cm_sched_amount_t( i ) );
2974: dbms_sql.bind_variable( rule_insert_dist_c,
2975: 'amount_2',
2976: cm_sched_amount_t( i ) );
2977: dbms_sql.bind_variable( rule_insert_dist_c,
2978: 'amount_3',
2979: cm_sched_amount_t( i ) );
2980: dbms_sql.bind_variable( rule_insert_dist_c,
2981: 'amount_4',

Line 2980: dbms_sql.bind_variable( rule_insert_dist_c,

2976: cm_sched_amount_t( i ) );
2977: dbms_sql.bind_variable( rule_insert_dist_c,
2978: 'amount_3',
2979: cm_sched_amount_t( i ) );
2980: dbms_sql.bind_variable( rule_insert_dist_c,
2981: 'amount_4',
2982: cm_sched_amount_t( i ) );
2983: dbms_sql.bind_variable( rule_insert_dist_c,
2984: 'amount_5',

Line 2983: dbms_sql.bind_variable( rule_insert_dist_c,

2979: cm_sched_amount_t( i ) );
2980: dbms_sql.bind_variable( rule_insert_dist_c,
2981: 'amount_4',
2982: cm_sched_amount_t( i ) );
2983: dbms_sql.bind_variable( rule_insert_dist_c,
2984: 'amount_5',
2985: cm_sched_amount_t( i ) );
2986: dbms_sql.bind_variable( rule_insert_dist_c,
2987: 'amount_6',

Line 2986: dbms_sql.bind_variable( rule_insert_dist_c,

2982: cm_sched_amount_t( i ) );
2983: dbms_sql.bind_variable( rule_insert_dist_c,
2984: 'amount_5',
2985: cm_sched_amount_t( i ) );
2986: dbms_sql.bind_variable( rule_insert_dist_c,
2987: 'amount_6',
2988: cm_sched_amount_t( i ) );
2989: /*7147479 changed bind variable insert_offset_1*/
2990: dbms_sql.bind_variable( rule_insert_dist_c,

Line 2990: dbms_sql.bind_variable( rule_insert_dist_c,

2986: dbms_sql.bind_variable( rule_insert_dist_c,
2987: 'amount_6',
2988: cm_sched_amount_t( i ) );
2989: /*7147479 changed bind variable insert_offset_1*/
2990: dbms_sql.bind_variable( rule_insert_dist_c,
2991: 'insert_offset_1',
2992: cm_sched_insert_offset_t( i ) );
2993: /*7147479 added extra bind variable insert_offset_2*/
2994: dbms_sql.bind_variable( rule_insert_dist_c,

Line 2994: dbms_sql.bind_variable( rule_insert_dist_c,

2990: dbms_sql.bind_variable( rule_insert_dist_c,
2991: 'insert_offset_1',
2992: cm_sched_insert_offset_t( i ) );
2993: /*7147479 added extra bind variable insert_offset_2*/
2994: dbms_sql.bind_variable( rule_insert_dist_c,
2995: 'insert_offset_2',
2996: cm_sched_insert_offset_t( i ) );
2997:
2998: dbms_sql.bind_variable( rule_insert_dist_c,

Line 2998: dbms_sql.bind_variable( rule_insert_dist_c,

2994: dbms_sql.bind_variable( rule_insert_dist_c,
2995: 'insert_offset_2',
2996: cm_sched_insert_offset_t( i ) );
2997:
2998: dbms_sql.bind_variable( rule_insert_dist_c,
2999: 'check_gl_date_1',
3000: cm_sched_check_gl_date_t( i ) );
3001:
3002:

Line 3007: dbms_sql.bind_variable( rule_insert_dist_c,

3003: /* Bug 2899714 - bind variable not defined when
3004: use_inv_acct set to no */
3005: IF( profile_info.use_inv_acct_for_cm_flag = YES ) THEN
3006: /* 4254587 */
3007: dbms_sql.bind_variable( rule_insert_dist_c,
3008: 'period_set_name',
3009: system_info.period_set_name );
3010:
3011: /* Bug 2347001 - session_id */

Line 3012: dbms_sql.bind_variable( rule_insert_dist_c,

3008: 'period_set_name',
3009: system_info.period_set_name );
3010:
3011: /* Bug 2347001 - session_id */
3012: dbms_sql.bind_variable( rule_insert_dist_c,
3013: 'session_id',
3014: g_session_id);
3015:
3016: /*7147479 - added new bind variables*/

Line 3017: dbms_sql.bind_variable( rule_insert_dist_c,

3013: 'session_id',
3014: g_session_id);
3015:
3016: /*7147479 - added new bind variables*/
3017: dbms_sql.bind_variable( rule_insert_dist_c,
3018: 'customer_trx_line_id_2',
3019: cm_sched_ctlid_t( i ) );
3020: dbms_sql.bind_variable( rule_insert_dist_c,
3021: 'original_gl_date_1',

Line 3020: dbms_sql.bind_variable( rule_insert_dist_c,

3016: /*7147479 - added new bind variables*/
3017: dbms_sql.bind_variable( rule_insert_dist_c,
3018: 'customer_trx_line_id_2',
3019: cm_sched_ctlid_t( i ) );
3020: dbms_sql.bind_variable( rule_insert_dist_c,
3021: 'original_gl_date_1',
3022: cm_sched_orig_gl_date_t( i ) );
3023: dbms_sql.bind_variable( rule_insert_dist_c,
3024: 'gl_date_2',

Line 3023: dbms_sql.bind_variable( rule_insert_dist_c,

3019: cm_sched_ctlid_t( i ) );
3020: dbms_sql.bind_variable( rule_insert_dist_c,
3021: 'original_gl_date_1',
3022: cm_sched_orig_gl_date_t( i ) );
3023: dbms_sql.bind_variable( rule_insert_dist_c,
3024: 'gl_date_2',
3025: cm_sched_gl_date_t( i ) );
3026: dbms_sql.bind_variable( rule_insert_dist_c,
3027: 'gl_date_3',

Line 3026: dbms_sql.bind_variable( rule_insert_dist_c,

3022: cm_sched_orig_gl_date_t( i ) );
3023: dbms_sql.bind_variable( rule_insert_dist_c,
3024: 'gl_date_2',
3025: cm_sched_gl_date_t( i ) );
3026: dbms_sql.bind_variable( rule_insert_dist_c,
3027: 'gl_date_3',
3028: cm_sched_gl_date_t( i ) );
3029: dbms_sql.bind_variable( rule_insert_dist_c,
3030: 'gl_date_4',

Line 3029: dbms_sql.bind_variable( rule_insert_dist_c,

3025: cm_sched_gl_date_t( i ) );
3026: dbms_sql.bind_variable( rule_insert_dist_c,
3027: 'gl_date_3',
3028: cm_sched_gl_date_t( i ) );
3029: dbms_sql.bind_variable( rule_insert_dist_c,
3030: 'gl_date_4',
3031: cm_sched_gl_date_t( i ) );
3032: /*bug-7147479 added For Use Invoice Accounting for CM is NO*/
3033: ELSE

Line 3035: dbms_sql.bind_variable( rule_insert_dist_c,

3031: cm_sched_gl_date_t( i ) );
3032: /*bug-7147479 added For Use Invoice Accounting for CM is NO*/
3033: ELSE
3034: /* in SELECT portion of statement */
3035: dbms_sql.bind_variable( rule_insert_dist_c,
3036: 'original_gl_date',
3037: cm_sched_orig_gl_date_t( i ) );
3038: /* in WHERE portion of statement */
3039: dbms_sql.bind_variable( rule_insert_dist_c,

Line 3039: dbms_sql.bind_variable( rule_insert_dist_c,

3035: dbms_sql.bind_variable( rule_insert_dist_c,
3036: 'original_gl_date',
3037: cm_sched_orig_gl_date_t( i ) );
3038: /* in WHERE portion of statement */
3039: dbms_sql.bind_variable( rule_insert_dist_c,
3040: 'gl_date_1',
3041: cm_sched_gl_date_t( i ) );
3042:
3043: dbms_sql.bind_variable( rule_insert_dist_c,

Line 3043: dbms_sql.bind_variable( rule_insert_dist_c,

3039: dbms_sql.bind_variable( rule_insert_dist_c,
3040: 'gl_date_1',
3041: cm_sched_gl_date_t( i ) );
3042:
3043: dbms_sql.bind_variable( rule_insert_dist_c,
3044: 'check_gl_date_2',
3045: cm_sched_check_gl_date_t( i ) );
3046: END IF;
3047:

Line 3059: l_ignore := dbms_sql.execute( rule_insert_dist_c );

3055: -- Execute
3056: -------------------------------------------------------------
3057: BEGIN
3058: arp_standard.debug( ' Inserting distributions');
3059: l_ignore := dbms_sql.execute( rule_insert_dist_c );
3060: EXCEPTION
3061: WHEN OTHERS THEN
3062: debug( 'EXCEPTION: Error executing insert dist stmt' );
3063: RAISE;

Line 3099: dbms_sql.bind_variable( rule_insert_cma_c,

3095:
3096: -------------------------------------------------------------
3097: -- Bind vars
3098: -------------------------------------------------------------
3099: dbms_sql.bind_variable( rule_insert_cma_c,
3100: 'customer_trx_line_id',
3101: cm_sched_ctlid_t( i ) );
3102: dbms_sql.bind_variable( rule_insert_cma_c,
3103: 'gl_date',

Line 3102: dbms_sql.bind_variable( rule_insert_cma_c,

3098: -------------------------------------------------------------
3099: dbms_sql.bind_variable( rule_insert_cma_c,
3100: 'customer_trx_line_id',
3101: cm_sched_ctlid_t( i ) );
3102: dbms_sql.bind_variable( rule_insert_cma_c,
3103: 'gl_date',
3104: l_original_gl_date);
3105: dbms_sql.bind_variable( rule_insert_cma_c,
3106: 'amount',

Line 3105: dbms_sql.bind_variable( rule_insert_cma_c,

3101: cm_sched_ctlid_t( i ) );
3102: dbms_sql.bind_variable( rule_insert_cma_c,
3103: 'gl_date',
3104: l_original_gl_date);
3105: dbms_sql.bind_variable( rule_insert_cma_c,
3106: 'amount',
3107: cm_sched_amount_t( i ) );
3108: -------------------------------------------------------------
3109: -- Execute

Line 3114: l_ignore := dbms_sql.execute( rule_insert_cma_c );

3110: -------------------------------------------------------------
3111: BEGIN
3112:
3113: debug( ' Inserting CM amounts', MSG_LEVEL_DEBUG );
3114: l_ignore := dbms_sql.execute( rule_insert_cma_c );
3115: debug( to_char(l_ignore) || ' row(s) inserted',
3116: MSG_LEVEL_DEBUG );
3117:
3118: EXCEPTION

Line 4793: dbms_sql.define_column( net_revenue_line_c, 1,

4789:
4790: BEGIN
4791: debug( ' Defining columns for net_revenue_line_c', MSG_LEVEL_BASIC );
4792:
4793: dbms_sql.define_column( net_revenue_line_c, 1,
4794: net_revenue_rec.customer_trx_line_id );
4795: dbms_sql.define_column( net_revenue_line_c, 2,
4796: net_revenue_rec.gl_date );
4797: dbms_sql.define_column( net_revenue_line_c, 3,

Line 4795: dbms_sql.define_column( net_revenue_line_c, 2,

4791: debug( ' Defining columns for net_revenue_line_c', MSG_LEVEL_BASIC );
4792:
4793: dbms_sql.define_column( net_revenue_line_c, 1,
4794: net_revenue_rec.customer_trx_line_id );
4795: dbms_sql.define_column( net_revenue_line_c, 2,
4796: net_revenue_rec.gl_date );
4797: dbms_sql.define_column( net_revenue_line_c, 3,
4798: net_revenue_rec.amount );
4799: dbms_sql.define_column( net_revenue_line_c, 4,

Line 4797: dbms_sql.define_column( net_revenue_line_c, 3,

4793: dbms_sql.define_column( net_revenue_line_c, 1,
4794: net_revenue_rec.customer_trx_line_id );
4795: dbms_sql.define_column( net_revenue_line_c, 2,
4796: net_revenue_rec.gl_date );
4797: dbms_sql.define_column( net_revenue_line_c, 3,
4798: net_revenue_rec.amount );
4799: dbms_sql.define_column( net_revenue_line_c, 4,
4800: net_revenue_rec.net_unit_price );
4801: dbms_sql.define_column( net_revenue_line_c, 5,

Line 4799: dbms_sql.define_column( net_revenue_line_c, 4,

4795: dbms_sql.define_column( net_revenue_line_c, 2,
4796: net_revenue_rec.gl_date );
4797: dbms_sql.define_column( net_revenue_line_c, 3,
4798: net_revenue_rec.amount );
4799: dbms_sql.define_column( net_revenue_line_c, 4,
4800: net_revenue_rec.net_unit_price );
4801: dbms_sql.define_column( net_revenue_line_c, 5,
4802: net_revenue_rec.inv_dist_exists, 1 );
4803: EXCEPTION

Line 4801: dbms_sql.define_column( net_revenue_line_c, 5,

4797: dbms_sql.define_column( net_revenue_line_c, 3,
4798: net_revenue_rec.amount );
4799: dbms_sql.define_column( net_revenue_line_c, 4,
4800: net_revenue_rec.net_unit_price );
4801: dbms_sql.define_column( net_revenue_line_c, 5,
4802: net_revenue_rec.inv_dist_exists, 1 );
4803: EXCEPTION
4804: WHEN OTHERS THEN
4805: debug( 'EXCEPTION: Error defining columns for net_revenue_line_c' );

Line 4812: dbms_sql.bind_variable( rule_select_cm_lines_c,

4808:
4809: /* bug fix 956189 */
4810: IF( p_cm_control.customer_trx_line_id IS NOT NULL ) THEN
4811: BEGIN
4812: dbms_sql.bind_variable( rule_select_cm_lines_c,
4813: 'cm_cust_trx_line_id',
4814: p_cm_control.customer_trx_line_id );
4815: EXCEPTION
4816: WHEN OTHERS THEN

Line 4824: dbms_sql.bind_variable( rule_select_cm_lines_c,

4820:
4821: ELSE
4822: IF( p_cm_control.customer_trx_id IS NOT NULL ) THEN
4823: BEGIN
4824: dbms_sql.bind_variable( rule_select_cm_lines_c,
4825: 'cm_customer_trx_id',
4826: p_cm_control.customer_trx_id );
4827: EXCEPTION
4828: WHEN OTHERS THEN

Line 4834: dbms_sql.bind_variable( rule_select_cm_lines_c,

4830: RAISE;
4831: END;
4832: ELSE /* bug 3525326 */
4833: BEGIN
4834: dbms_sql.bind_variable( rule_select_cm_lines_c,
4835: 'request_id',
4836: p_cm_control.request_id );
4837: EXCEPTION
4838: WHEN OTHERS THEN

Line 4848: dbms_sql.bind_variable( rule_insert_cma_c,

4844:
4845: /* bug 3525326 */
4846: IF (p_cm_control.request_id IS NOT NULL) THEN
4847: BEGIN
4848: dbms_sql.bind_variable( rule_insert_cma_c,
4849: 'request_id',
4850: p_cm_control.request_id );
4851: EXCEPTION
4852: WHEN OTHERS THEN

Line 4888: l_ignore := dbms_sql.execute( rule_select_cm_lines_c );

4884: ---------------------------------------------------------------
4885: debug( ' Executing select sql', MSG_LEVEL_DEBUG );
4886:
4887: BEGIN
4888: l_ignore := dbms_sql.execute( rule_select_cm_lines_c );
4889:
4890: EXCEPTION
4891: WHEN OTHERS THEN
4892: debug( 'EXCEPTION: Error executing select cm lines sql' );

Line 4907: IF dbms_sql.fetch_rows( rule_select_cm_lines_c ) > 0 THEN

4903: BEGIN
4904: LOOP
4905:
4906:
4907: IF dbms_sql.fetch_rows( rule_select_cm_lines_c ) > 0 THEN
4908:
4909: debug(' fetched a row', MSG_LEVEL_DEBUG );
4910:
4911: l_first_fetch := FALSE;

Line 5004: dbms_sql.bind_variable( rule_update_cm_lines_c,

5000: debug(' cm_acct_rule_duration='||
5001: l_select_rec.cm_acct_rule_duration,
5002: MSG_LEVEL_DEBUG);
5003:
5004: dbms_sql.bind_variable( rule_update_cm_lines_c,
5005: 'rule_start_date',
5006: l_select_rec.rule_start_date );
5007: dbms_sql.bind_variable( rule_update_cm_lines_c,
5008: 'rule_end_date',

Line 5007: dbms_sql.bind_variable( rule_update_cm_lines_c,

5003:
5004: dbms_sql.bind_variable( rule_update_cm_lines_c,
5005: 'rule_start_date',
5006: l_select_rec.rule_start_date );
5007: dbms_sql.bind_variable( rule_update_cm_lines_c,
5008: 'rule_end_date',
5009: l_select_rec.rule_end_date );
5010: dbms_sql.bind_variable( rule_update_cm_lines_c,
5011: 'cm_acct_rule_duration',

Line 5010: dbms_sql.bind_variable( rule_update_cm_lines_c,

5006: l_select_rec.rule_start_date );
5007: dbms_sql.bind_variable( rule_update_cm_lines_c,
5008: 'rule_end_date',
5009: l_select_rec.rule_end_date );
5010: dbms_sql.bind_variable( rule_update_cm_lines_c,
5011: 'cm_acct_rule_duration',
5012: l_select_rec.cm_acct_rule_duration );
5013: dbms_sql.bind_variable( rule_update_cm_lines_c,
5014: 'credit_method',

Line 5013: dbms_sql.bind_variable( rule_update_cm_lines_c,

5009: l_select_rec.rule_end_date );
5010: dbms_sql.bind_variable( rule_update_cm_lines_c,
5011: 'cm_acct_rule_duration',
5012: l_select_rec.cm_acct_rule_duration );
5013: dbms_sql.bind_variable( rule_update_cm_lines_c,
5014: 'credit_method',
5015: l_select_rec.credit_method_for_rules);
5016: dbms_sql.bind_variable( rule_update_cm_lines_c,
5017: 'last_period_to_credit',

Line 5016: dbms_sql.bind_variable( rule_update_cm_lines_c,

5012: l_select_rec.cm_acct_rule_duration );
5013: dbms_sql.bind_variable( rule_update_cm_lines_c,
5014: 'credit_method',
5015: l_select_rec.credit_method_for_rules);
5016: dbms_sql.bind_variable( rule_update_cm_lines_c,
5017: 'last_period_to_credit',
5018: l_select_rec.last_period_to_credit );
5019: dbms_sql.bind_variable( rule_update_cm_lines_c,
5020: 'customer_trx_line_id',

Line 5019: dbms_sql.bind_variable( rule_update_cm_lines_c,

5015: l_select_rec.credit_method_for_rules);
5016: dbms_sql.bind_variable( rule_update_cm_lines_c,
5017: 'last_period_to_credit',
5018: l_select_rec.last_period_to_credit );
5019: dbms_sql.bind_variable( rule_update_cm_lines_c,
5020: 'customer_trx_line_id',
5021: l_select_rec.customer_trx_line_id );
5022: EXCEPTION
5023: WHEN OTHERS THEN

Line 5034: l_ignore := dbms_sql.execute( rule_update_cm_lines_c );

5030: -----------------------------------------------------------
5031: debug( ' Updating lines', MSG_LEVEL_DEBUG );
5032:
5033: BEGIN
5034: l_ignore := dbms_sql.execute( rule_update_cm_lines_c );
5035:
5036: debug( to_char(l_ignore) || ' row(s) updated',
5037: MSG_LEVEL_DEBUG );
5038:

Line 5565: gl_header_dist_array dbms_sql.number_table; /* mrc */

5561: p_run_autoaccounting_flag IN BOOLEAN
5562: ) IS
5563:
5564: l_ignore INTEGER;
5565: gl_header_dist_array dbms_sql.number_table; /* mrc */
5566: gl_line_dist_array dbms_sql.number_table; /* mrc */
5567: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE; -- bug5870933
5568:
5569: BEGIN

Line 5566: gl_line_dist_array dbms_sql.number_table; /* mrc */

5562: ) IS
5563:
5564: l_ignore INTEGER;
5565: gl_header_dist_array dbms_sql.number_table; /* mrc */
5566: gl_line_dist_array dbms_sql.number_table; /* mrc */
5567: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE; -- bug5870933
5568:
5569: BEGIN
5570: print_fcn_label('arp_credit_memo_module.credit_transactions()+' );

Line 5604: IF( NOT( dbms_sql.is_open( delete_header_dist_c ) AND

5600: -- Process Update mode
5601: ------------------------------
5602: debug( ' Update mode', MSG_LEVEL_DEBUG );
5603:
5604: IF( NOT( dbms_sql.is_open( delete_header_dist_c ) AND
5605: dbms_sql.is_open( delete_line_dist_c ) AND
5606: dbms_sql.is_open( delete_header_cma_c ) AND
5607: dbms_sql.is_open( delete_line_cma_c ) AND
5608: dbms_sql.is_open( update_header_lines_c ) AND

Line 5605: dbms_sql.is_open( delete_line_dist_c ) AND

5601: ------------------------------
5602: debug( ' Update mode', MSG_LEVEL_DEBUG );
5603:
5604: IF( NOT( dbms_sql.is_open( delete_header_dist_c ) AND
5605: dbms_sql.is_open( delete_line_dist_c ) AND
5606: dbms_sql.is_open( delete_header_cma_c ) AND
5607: dbms_sql.is_open( delete_line_cma_c ) AND
5608: dbms_sql.is_open( update_header_lines_c ) AND
5609: dbms_sql.is_open( update_lines_c ) ) ) THEN

Line 5606: dbms_sql.is_open( delete_header_cma_c ) AND

5602: debug( ' Update mode', MSG_LEVEL_DEBUG );
5603:
5604: IF( NOT( dbms_sql.is_open( delete_header_dist_c ) AND
5605: dbms_sql.is_open( delete_line_dist_c ) AND
5606: dbms_sql.is_open( delete_header_cma_c ) AND
5607: dbms_sql.is_open( delete_line_cma_c ) AND
5608: dbms_sql.is_open( update_header_lines_c ) AND
5609: dbms_sql.is_open( update_lines_c ) ) ) THEN
5610:

Line 5607: dbms_sql.is_open( delete_line_cma_c ) AND

5603:
5604: IF( NOT( dbms_sql.is_open( delete_header_dist_c ) AND
5605: dbms_sql.is_open( delete_line_dist_c ) AND
5606: dbms_sql.is_open( delete_header_cma_c ) AND
5607: dbms_sql.is_open( delete_line_cma_c ) AND
5608: dbms_sql.is_open( update_header_lines_c ) AND
5609: dbms_sql.is_open( update_lines_c ) ) ) THEN
5610:
5611: ----------------------------------------------------------------

Line 5608: dbms_sql.is_open( update_header_lines_c ) AND

5604: IF( NOT( dbms_sql.is_open( delete_header_dist_c ) AND
5605: dbms_sql.is_open( delete_line_dist_c ) AND
5606: dbms_sql.is_open( delete_header_cma_c ) AND
5607: dbms_sql.is_open( delete_line_cma_c ) AND
5608: dbms_sql.is_open( update_header_lines_c ) AND
5609: dbms_sql.is_open( update_lines_c ) ) ) THEN
5610:
5611: ----------------------------------------------------------------
5612: -- Build dynamic sql

Line 5609: dbms_sql.is_open( update_lines_c ) ) ) THEN

5605: dbms_sql.is_open( delete_line_dist_c ) AND
5606: dbms_sql.is_open( delete_header_cma_c ) AND
5607: dbms_sql.is_open( delete_line_cma_c ) AND
5608: dbms_sql.is_open( update_header_lines_c ) AND
5609: dbms_sql.is_open( update_lines_c ) ) ) THEN
5610:
5611: ----------------------------------------------------------------
5612: -- Build dynamic sql
5613: ----------------------------------------------------------------

Line 5642: dbms_sql.bind_variable(

5638:
5639: ---------------------------------------------------------------
5640: -- Bind variables
5641: ---------------------------------------------------------------
5642: dbms_sql.bind_variable(
5643: delete_line_dist_c,
5644: 'customer_trx_line_id',
5645: p_customer_trx_line_id );
5646:

Line 5647: dbms_sql.bind_variable(

5643: delete_line_dist_c,
5644: 'customer_trx_line_id',
5645: p_customer_trx_line_id );
5646:
5647: dbms_sql.bind_variable(
5648: delete_line_cma_c,
5649: 'customer_trx_line_id',
5650: p_customer_trx_line_id );
5651:

Line 5652: dbms_sql.bind_variable(

5648: delete_line_cma_c,
5649: 'customer_trx_line_id',
5650: p_customer_trx_line_id );
5651:
5652: dbms_sql.bind_variable(
5653: update_lines_c,
5654: 'customer_trx_line_id',
5655: p_customer_trx_line_id );
5656:

Line 5660: dbms_sql.bind_array(delete_line_dist_c, ':gl_dist_key_value',

5656:
5657: --------------------------------------------------------------
5658: -- Bind output variables
5659: --------------------------------------------------------------
5660: dbms_sql.bind_array(delete_line_dist_c, ':gl_dist_key_value',
5661: gl_line_dist_array);
5662:
5663:
5664: ---------------------------------------------------------------

Line 5669: l_ignore := dbms_sql.execute( delete_line_dist_c );

5665: -- Execute sql
5666: ---------------------------------------------------------------
5667: debug( ' Executing delete dist sql', MSG_LEVEL_DEBUG );
5668: BEGIN
5669: l_ignore := dbms_sql.execute( delete_line_dist_c );
5670:
5671: debug( to_char(l_ignore) || ' row(s) deleted',
5672: MSG_LEVEL_DEBUG );
5673:

Line 5678: dbms_sql.variable_value( delete_line_dist_c,

5674: /*------------------------------------------+
5675: | get RETURNING COLUMN into OUT NOCOPY bind array |
5676: +------------------------------------------*/
5677:
5678: dbms_sql.variable_value( delete_line_dist_c,
5679: ':gl_dist_key_value',
5680: gl_line_dist_array);
5681: EXCEPTION
5682: WHEN OTHERS THEN

Line 5689: l_ignore := dbms_sql.execute( delete_line_cma_c );

5685: END;
5686:
5687: debug( ' Executing delete cma sql', MSG_LEVEL_DEBUG );
5688: BEGIN
5689: l_ignore := dbms_sql.execute( delete_line_cma_c );
5690:
5691: debug( to_char(l_ignore) || ' row(s) deleted',
5692: MSG_LEVEL_DEBUG );
5693: EXCEPTION

Line 5701: l_ignore := dbms_sql.execute( update_lines_c );

5697: END;
5698:
5699: debug( ' Executing update lines sql', MSG_LEVEL_DEBUG );
5700: BEGIN
5701: l_ignore := dbms_sql.execute( update_lines_c );
5702:
5703: debug( to_char(l_ignore) || ' row(s) updated',
5704: MSG_LEVEL_DEBUG );
5705: EXCEPTION

Line 5721: dbms_sql.bind_variable(

5717:
5718: ---------------------------------------------------------------
5719: -- Bind variables
5720: ---------------------------------------------------------------
5721: dbms_sql.bind_variable(
5722: delete_header_dist_c,
5723: 'customer_trx_id',
5724: p_customer_trx_id );
5725:

Line 5726: dbms_sql.bind_variable(

5722: delete_header_dist_c,
5723: 'customer_trx_id',
5724: p_customer_trx_id );
5725:
5726: dbms_sql.bind_variable(
5727: delete_header_cma_c,
5728: 'customer_trx_id',
5729: p_customer_trx_id );
5730:

Line 5731: dbms_sql.bind_variable(

5727: delete_header_cma_c,
5728: 'customer_trx_id',
5729: p_customer_trx_id );
5730:
5731: dbms_sql.bind_variable(
5732: update_header_lines_c,
5733: 'customer_trx_id',
5734: p_customer_trx_id );
5735:

Line 5739: dbms_sql.bind_array(delete_header_dist_c, ':gl_dist_key_value',

5735:
5736: --------------------------------------------------------------
5737: -- Bind output variables
5738: --------------------------------------------------------------
5739: dbms_sql.bind_array(delete_header_dist_c, ':gl_dist_key_value',
5740: gl_header_dist_array);
5741:
5742: ---------------------------------------------------------------
5743: -- Execute sql

Line 5747: l_ignore := dbms_sql.execute( delete_header_dist_c );

5743: -- Execute sql
5744: ---------------------------------------------------------------
5745: debug( ' Executing delete dist sql', MSG_LEVEL_DEBUG );
5746: BEGIN
5747: l_ignore := dbms_sql.execute( delete_header_dist_c );
5748:
5749: debug( to_char(l_ignore) || ' row(s) deleted',
5750: MSG_LEVEL_DEBUG );
5751: /*------------------------------------------+

Line 5755: dbms_sql.variable_value( delete_header_dist_c,

5751: /*------------------------------------------+
5752: | get RETURNING COLUMN into OUT NOCOPY bind array |
5753: +------------------------------------------*/
5754:
5755: dbms_sql.variable_value( delete_header_dist_c,
5756: ':gl_dist_key_value',
5757: gl_header_dist_array);
5758: EXCEPTION
5759: WHEN OTHERS THEN

Line 5766: l_ignore := dbms_sql.execute( delete_header_cma_c );

5762: END;
5763:
5764: debug( ' Executing delete cma sql', MSG_LEVEL_DEBUG );
5765: BEGIN
5766: l_ignore := dbms_sql.execute( delete_header_cma_c );
5767:
5768: debug( to_char(l_ignore) || ' row(s) deleted',
5769: MSG_LEVEL_DEBUG );
5770: EXCEPTION

Line 5778: l_ignore := dbms_sql.execute( update_header_lines_c );

5774: END;
5775:
5776: debug( ' Executing update lines sql', MSG_LEVEL_DEBUG );
5777: BEGIN
5778: l_ignore := dbms_sql.execute( update_header_lines_c );
5779:
5780: debug( to_char(l_ignore) || ' row(s) updated',
5781: MSG_LEVEL_DEBUG );
5782: EXCEPTION