APPS.ARRX_RC dependencies on FA_RX_FLEX_PKG

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

598: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN
599: CO_SEG_WHERE := NULL;
600: ELSIF var.p_co_seg_low IS NULL THEN
601: CO_SEG_WHERE := ' AND ' ||
602: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
603: p_id_flex_code => 'GL#',
604: p_id_flex_num => var.p_coa_id,
605: p_table_alias => 'CC',
606: p_mode => 'WHERE',

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

608: p_function => '<=',
609: p_operand1 => var.p_co_seg_high);
610: ELSIF var.p_co_seg_high IS NULL THEN
611: CO_SEG_WHERE := ' AND ' ||
612: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
613: p_id_flex_code => 'GL#',
614: p_id_flex_num => var.p_coa_id,
615: p_table_alias => 'CC',
616: p_mode => 'WHERE',

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

618: p_function => '>=',
619: p_operand1 => var.p_co_seg_low);
620: ELSE
621: CO_SEG_WHERE := ' AND ' ||
622: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
623: p_id_flex_code => 'GL#',
624: p_id_flex_num => var.p_coa_id,
625: p_table_alias => 'CC',
626: p_mode => 'WHERE',

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

802: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN
803: CO_SEG_WHERE := NULL;
804: ELSIF var.p_co_seg_low IS NULL THEN
805: CO_SEG_WHERE := ' AND ' ||
806: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
807: p_id_flex_code => 'GL#',
808: p_id_flex_num => var.chart_of_accounts_id,
809: p_table_alias => 'CC2',
810: p_mode => 'WHERE',

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

812: p_function => '<=',
813: p_operand1 => var.p_co_seg_high);
814: ELSIF var.p_co_seg_high IS NULL THEN
815: CO_SEG_WHERE := ' AND ' ||
816: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
817: p_id_flex_code => 'GL#',
818: p_id_flex_num => var.chart_of_accounts_id,
819: p_table_alias => 'CC2',
820: p_mode => 'WHERE',

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

822: p_function => '>=',
823: p_operand1 => var.p_co_seg_low);
824: ELSE
825: CO_SEG_WHERE := ' AND ' ||
826: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
827: p_id_flex_code => 'GL#',
828: p_id_flex_num => var.chart_of_accounts_id,
829: p_table_alias => 'CC2',
830: p_mode => 'WHERE',

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

1036: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN
1037: CO_SEG_WHERE := NULL;
1038: ELSIF var.p_co_seg_low IS NULL THEN
1039: CO_SEG_WHERE := ' AND ' ||
1040: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
1041: p_id_flex_code => 'GL#',
1042: p_id_flex_num => var.chart_of_accounts_id,
1043: p_table_alias => 'CC2',
1044: p_mode => 'WHERE',

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

1046: p_function => '<=',
1047: p_operand1 => var.p_co_seg_high);
1048: ELSIF var.p_co_seg_high IS NULL THEN
1049: CO_SEG_WHERE := ' AND ' ||
1050: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
1051: p_id_flex_code => 'GL#',
1052: p_id_flex_num => var.chart_of_accounts_id,
1053: p_table_alias => 'CC2',
1054: p_mode => 'WHERE',

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

1056: p_function => '>=',
1057: p_operand1 => var.p_co_seg_low);
1058: ELSE
1059: CO_SEG_WHERE := ' AND ' ||
1060: FA_RX_FLEX_PKG.FLEX_SQL(p_application_id => 101,
1061: p_id_flex_code => 'GL#',
1062: p_id_flex_num => var.chart_of_accounts_id,
1063: p_table_alias => 'CC2',
1064: p_mode => 'WHERE',

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

1321: where cash_receipt_id = var.cash_receipt_id;
1322: END IF;
1323: END IF;
1324:
1325: var.debit_account := fa_rx_flex_pkg.get_value(
1326: p_application_id => 101,
1327: p_id_flex_code => 'GL#',
1328: p_id_flex_num => var.chart_of_accounts_id,
1329: p_qualifier => 'ALL',

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

1328: p_id_flex_num => var.chart_of_accounts_id,
1329: p_qualifier => 'ALL',
1330: p_ccid => var.account_code_combination_id);
1331:
1332: var.debit_account_desc := substrb(fa_rx_flex_pkg.get_description (
1333: p_application_id => 101,
1334: p_id_flex_code => 'GL#',
1335: p_id_flex_num => var.chart_of_accounts_id,
1336: p_qualifier => 'ALL',

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

1335: p_id_flex_num => var.chart_of_accounts_id,
1336: p_qualifier => 'ALL',
1337: p_data => var.debit_account),1,240);
1338:
1339: var.debit_balancing := fa_rx_flex_pkg.get_value(
1340: p_application_id => 101,
1341: p_id_flex_code => 'GL#',
1342: p_id_flex_num => var.chart_of_accounts_id,
1343: p_qualifier => 'GL_BALANCING',

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

1342: p_id_flex_num => var.chart_of_accounts_id,
1343: p_qualifier => 'GL_BALANCING',
1344: p_ccid => var.account_code_combination_id);
1345:
1346: var.debit_balancing_desc := substrb(fa_rx_flex_pkg.get_description(
1347: p_application_id => 101,
1348: p_id_flex_code => 'GL#',
1349: p_id_flex_num => var.chart_of_accounts_id,
1350: p_qualifier => 'GL_BALANCING',

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

1349: p_id_flex_num => var.chart_of_accounts_id,
1350: p_qualifier => 'GL_BALANCING',
1351: p_data => var.debit_balancing),1,240);
1352:
1353: var.debit_natacct := fa_rx_flex_pkg.get_value(
1354: p_application_id => 101,
1355: p_id_flex_code => 'GL#',
1356: p_id_flex_num => var.chart_of_accounts_id,
1357: p_qualifier => 'GL_ACCOUNT',

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

1356: p_id_flex_num => var.chart_of_accounts_id,
1357: p_qualifier => 'GL_ACCOUNT',
1358: p_ccid => var.account_code_combination_id);
1359:
1360: var.debit_natacct_desc := substrb(fa_rx_flex_pkg.get_description(
1361: p_application_id => 101,
1362: p_id_flex_code => 'GL#',
1363: p_id_flex_num => var.chart_of_accounts_id,
1364: p_qualifier => 'GL_ACCOUNT',