APPS.ARRX_RC dependencies on FA_RX_FLEX_PKG

Line 662: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,

658: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN
659: CO_SEG_WHERE := NULL;
660: ELSIF var.p_co_seg_low IS NULL THEN
661: CO_SEG_WHERE := ' AND ' ||
662: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
663: p_id_flex_code => 'GL#',
664: p_id_flex_num => var.p_coa_id,
665: p_table_alias => 'CC',
666: p_mode => 'WHERE',

Line 672: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,

668: p_function => '<=',
669: p_operand1 => var.p_co_seg_high);
670: ELSIF var.p_co_seg_high IS NULL THEN
671: CO_SEG_WHERE := ' AND ' ||
672: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
673: p_id_flex_code => 'GL#',
674: p_id_flex_num => var.p_coa_id,
675: p_table_alias => 'CC',
676: p_mode => 'WHERE',

Line 682: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,

678: p_function => '>=',
679: p_operand1 => var.p_co_seg_low);
680: ELSE
681: CO_SEG_WHERE := ' AND ' ||
682: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
683: p_id_flex_code => 'GL#',
684: p_id_flex_num => var.p_coa_id,
685: p_table_alias => 'CC',
686: p_mode => 'WHERE',

Line 864: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,

860: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN
861: CO_SEG_WHERE := NULL;
862: ELSIF var.p_co_seg_low IS NULL THEN
863: CO_SEG_WHERE := ' AND ' ||
864: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
865: p_id_flex_code => 'GL#',
866: p_id_flex_num => var.chart_of_accounts_id,
867: p_table_alias => 'CC2',
868: p_mode => 'WHERE',

Line 874: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,

870: p_function => '<=',
871: p_operand1 => var.p_co_seg_high);
872: ELSIF var.p_co_seg_high IS NULL THEN
873: CO_SEG_WHERE := ' AND ' ||
874: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
875: p_id_flex_code => 'GL#',
876: p_id_flex_num => var.chart_of_accounts_id,
877: p_table_alias => 'CC2',
878: p_mode => 'WHERE',

Line 884: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,

880: p_function => '>=',
881: p_operand1 => var.p_co_seg_low);
882: ELSE
883: CO_SEG_WHERE := ' AND ' ||
884: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
885: p_id_flex_code => 'GL#',
886: p_id_flex_num => var.chart_of_accounts_id,
887: p_table_alias => 'CC2',
888: p_mode => 'WHERE',

Line 1094: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,

1090: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN
1091: CO_SEG_WHERE := NULL;
1092: ELSIF var.p_co_seg_low IS NULL THEN
1093: CO_SEG_WHERE := ' AND ' ||
1094: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
1095: p_id_flex_code => 'GL#',
1096: p_id_flex_num => var.chart_of_accounts_id,
1097: p_table_alias => 'CC2',
1098: p_mode => 'WHERE',

Line 1104: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,

1100: p_function => '<=',
1101: p_operand1 => var.p_co_seg_high);
1102: ELSIF var.p_co_seg_high IS NULL THEN
1103: CO_SEG_WHERE := ' AND ' ||
1104: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
1105: p_id_flex_code => 'GL#',
1106: p_id_flex_num => var.chart_of_accounts_id,
1107: p_table_alias => 'CC2',
1108: p_mode => 'WHERE',

Line 1114: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,

1110: p_function => '>=',
1111: p_operand1 => var.p_co_seg_low);
1112: ELSE
1113: CO_SEG_WHERE := ' AND ' ||
1114: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
1115: p_id_flex_code => 'GL#',
1116: p_id_flex_num => var.chart_of_accounts_id,
1117: p_table_alias => 'CC2',
1118: p_mode => 'WHERE',

Line 1398: var.debit_account := fa_rx_flex_pkg.get_value(

1394: where cash_receipt_id = var.cash_receipt_id;
1395: END IF;
1396: END IF;
1397:
1398: var.debit_account := fa_rx_flex_pkg.get_value(
1399: p_application_id => 101,
1400: p_id_flex_code => 'GL#',
1401: p_id_flex_num => var.chart_of_accounts_id,
1402: p_qualifier => 'ALL',

Line 1405: var.debit_account_desc := substrb(fa_rx_flex_pkg.get_description (

1401: p_id_flex_num => var.chart_of_accounts_id,
1402: p_qualifier => 'ALL',
1403: p_ccid => var.account_code_combination_id);
1404:
1405: var.debit_account_desc := substrb(fa_rx_flex_pkg.get_description (
1406: p_application_id => 101,
1407: p_id_flex_code => 'GL#',
1408: p_id_flex_num => var.chart_of_accounts_id,
1409: p_qualifier => 'ALL',

Line 1412: var.debit_balancing := fa_rx_flex_pkg.get_value(

1408: p_id_flex_num => var.chart_of_accounts_id,
1409: p_qualifier => 'ALL',
1410: p_data => var.debit_account),1,240);
1411:
1412: var.debit_balancing := fa_rx_flex_pkg.get_value(
1413: p_application_id => 101,
1414: p_id_flex_code => 'GL#',
1415: p_id_flex_num => var.chart_of_accounts_id,
1416: p_qualifier => 'GL_BALANCING',

Line 1419: var.debit_balancing_desc := substrb(fa_rx_flex_pkg.get_description(

1415: p_id_flex_num => var.chart_of_accounts_id,
1416: p_qualifier => 'GL_BALANCING',
1417: p_ccid => var.account_code_combination_id);
1418:
1419: var.debit_balancing_desc := substrb(fa_rx_flex_pkg.get_description(
1420: p_application_id => 101,
1421: p_id_flex_code => 'GL#',
1422: p_id_flex_num => var.chart_of_accounts_id,
1423: p_qualifier => 'GL_BALANCING',

Line 1426: var.debit_natacct := fa_rx_flex_pkg.get_value(

1422: p_id_flex_num => var.chart_of_accounts_id,
1423: p_qualifier => 'GL_BALANCING',
1424: p_data => var.debit_balancing),1,240);
1425:
1426: var.debit_natacct := fa_rx_flex_pkg.get_value(
1427: p_application_id => 101,
1428: p_id_flex_code => 'GL#',
1429: p_id_flex_num => var.chart_of_accounts_id,
1430: p_qualifier => 'GL_ACCOUNT',

Line 1433: var.debit_natacct_desc := substrb(fa_rx_flex_pkg.get_description(

1429: p_id_flex_num => var.chart_of_accounts_id,
1430: p_qualifier => 'GL_ACCOUNT',
1431: p_ccid => var.account_code_combination_id);
1432:
1433: var.debit_natacct_desc := substrb(fa_rx_flex_pkg.get_description(
1434: p_application_id => 101,
1435: p_id_flex_code => 'GL#',
1436: p_id_flex_num => var.chart_of_accounts_id,
1437: p_qualifier => 'GL_ACCOUNT',