DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on FND_PROFILE

Line 1083: fnd_profile.value('PROG_APPL_ID'),

1079: SYSDATE,
1080: v_created_by,/* Aiyer for the bug 4565665. Added the columns last_update_date and last_updated_by */
1081: SYSDATE,
1082: v_created_by,
1083: fnd_profile.value('PROG_APPL_ID'),
1084: fnd_profile.value('CONC_PROGRAM_ID'),
1085: fnd_profile.value('CONC_LOGIN_ID'),
1086: fnd_profile.value('CONC_REQUEST_ID')
1087: )returning batch_id into v_batch_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 1084: fnd_profile.value('CONC_PROGRAM_ID'),

1080: v_created_by,/* Aiyer for the bug 4565665. Added the columns last_update_date and last_updated_by */
1081: SYSDATE,
1082: v_created_by,
1083: fnd_profile.value('PROG_APPL_ID'),
1084: fnd_profile.value('CONC_PROGRAM_ID'),
1085: fnd_profile.value('CONC_LOGIN_ID'),
1086: fnd_profile.value('CONC_REQUEST_ID')
1087: )returning batch_id into v_batch_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1088:

Line 1085: fnd_profile.value('CONC_LOGIN_ID'),

1081: SYSDATE,
1082: v_created_by,
1083: fnd_profile.value('PROG_APPL_ID'),
1084: fnd_profile.value('CONC_PROGRAM_ID'),
1085: fnd_profile.value('CONC_LOGIN_ID'),
1086: fnd_profile.value('CONC_REQUEST_ID')
1087: )returning batch_id into v_batch_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1088:
1089: COMMIT;

Line 1086: fnd_profile.value('CONC_REQUEST_ID')

1082: v_created_by,
1083: fnd_profile.value('PROG_APPL_ID'),
1084: fnd_profile.value('CONC_PROGRAM_ID'),
1085: fnd_profile.value('CONC_LOGIN_ID'),
1086: fnd_profile.value('CONC_REQUEST_ID')
1087: )returning batch_id into v_batch_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1088:
1089: COMMIT;
1090:

Line 1427: fnd_profile.value('PROG_APPL_ID'),

1423: shipment_rec.document_no,
1424: shipment_rec.line_num,
1425: shipment_rec.shipment_num,
1426: shipment_rec.tax_category_id,
1427: fnd_profile.value('PROG_APPL_ID'),
1428: fnd_profile.value('CONC_PROGRAM_ID'),
1429: fnd_profile.value('CONC_LOGIN_ID'),
1430: fnd_profile.value('CONC_REQUEST_ID'),
1431: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */

Line 1428: fnd_profile.value('CONC_PROGRAM_ID'),

1424: shipment_rec.line_num,
1425: shipment_rec.shipment_num,
1426: shipment_rec.tax_category_id,
1427: fnd_profile.value('PROG_APPL_ID'),
1428: fnd_profile.value('CONC_PROGRAM_ID'),
1429: fnd_profile.value('CONC_LOGIN_ID'),
1430: fnd_profile.value('CONC_REQUEST_ID'),
1431: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1432: sysdate,

Line 1429: fnd_profile.value('CONC_LOGIN_ID'),

1425: shipment_rec.shipment_num,
1426: shipment_rec.tax_category_id,
1427: fnd_profile.value('PROG_APPL_ID'),
1428: fnd_profile.value('CONC_PROGRAM_ID'),
1429: fnd_profile.value('CONC_LOGIN_ID'),
1430: fnd_profile.value('CONC_REQUEST_ID'),
1431: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1432: sysdate,
1433: v_created_by,

Line 1430: fnd_profile.value('CONC_REQUEST_ID'),

1426: shipment_rec.tax_category_id,
1427: fnd_profile.value('PROG_APPL_ID'),
1428: fnd_profile.value('CONC_PROGRAM_ID'),
1429: fnd_profile.value('CONC_LOGIN_ID'),
1430: fnd_profile.value('CONC_REQUEST_ID'),
1431: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1432: sysdate,
1433: v_created_by,
1434: sysdate

Line 1876: fnd_profile.value('PROG_APPL_ID'),

1872: shipment_rec.shipment_num,
1873: shipment_rec.tax_category_id,
1874: v_dflt_tax_category_id,
1875: v_message,
1876: fnd_profile.value('PROG_APPL_ID'),
1877: fnd_profile.value('CONC_PROGRAM_ID'),
1878: fnd_profile.value('CONC_LOGIN_ID'),
1879: fnd_profile.value('CONC_REQUEST_ID'),
1880: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */

Line 1877: fnd_profile.value('CONC_PROGRAM_ID'),

1873: shipment_rec.tax_category_id,
1874: v_dflt_tax_category_id,
1875: v_message,
1876: fnd_profile.value('PROG_APPL_ID'),
1877: fnd_profile.value('CONC_PROGRAM_ID'),
1878: fnd_profile.value('CONC_LOGIN_ID'),
1879: fnd_profile.value('CONC_REQUEST_ID'),
1880: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1881: sysdate,

Line 1878: fnd_profile.value('CONC_LOGIN_ID'),

1874: v_dflt_tax_category_id,
1875: v_message,
1876: fnd_profile.value('PROG_APPL_ID'),
1877: fnd_profile.value('CONC_PROGRAM_ID'),
1878: fnd_profile.value('CONC_LOGIN_ID'),
1879: fnd_profile.value('CONC_REQUEST_ID'),
1880: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1881: sysdate,
1882: v_created_by,

Line 1879: fnd_profile.value('CONC_REQUEST_ID'),

1875: v_message,
1876: fnd_profile.value('PROG_APPL_ID'),
1877: fnd_profile.value('CONC_PROGRAM_ID'),
1878: fnd_profile.value('CONC_LOGIN_ID'),
1879: fnd_profile.value('CONC_REQUEST_ID'),
1880: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1881: sysdate,
1882: v_created_by,
1883: sysdate

Line 1990: fnd_profile.value('PROG_APPL_ID'),

1986: releases_rec.release_num,
1987: releases_rec.line_num,
1988: releases_rec.shipment_num,
1989: releases_rec.tax_category_id,
1990: fnd_profile.value('PROG_APPL_ID'),
1991: fnd_profile.value('CONC_PROGRAM_ID'),
1992: fnd_profile.value('CONC_LOGIN_ID'),
1993: fnd_profile.value('CONC_REQUEST_ID'),
1994: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */

Line 1991: fnd_profile.value('CONC_PROGRAM_ID'),

1987: releases_rec.line_num,
1988: releases_rec.shipment_num,
1989: releases_rec.tax_category_id,
1990: fnd_profile.value('PROG_APPL_ID'),
1991: fnd_profile.value('CONC_PROGRAM_ID'),
1992: fnd_profile.value('CONC_LOGIN_ID'),
1993: fnd_profile.value('CONC_REQUEST_ID'),
1994: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1995: sysdate,

Line 1992: fnd_profile.value('CONC_LOGIN_ID'),

1988: releases_rec.shipment_num,
1989: releases_rec.tax_category_id,
1990: fnd_profile.value('PROG_APPL_ID'),
1991: fnd_profile.value('CONC_PROGRAM_ID'),
1992: fnd_profile.value('CONC_LOGIN_ID'),
1993: fnd_profile.value('CONC_REQUEST_ID'),
1994: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1995: sysdate,
1996: v_created_by,

Line 1993: fnd_profile.value('CONC_REQUEST_ID'),

1989: releases_rec.tax_category_id,
1990: fnd_profile.value('PROG_APPL_ID'),
1991: fnd_profile.value('CONC_PROGRAM_ID'),
1992: fnd_profile.value('CONC_LOGIN_ID'),
1993: fnd_profile.value('CONC_REQUEST_ID'),
1994: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1995: sysdate,
1996: v_created_by,
1997: sysdate

Line 2439: fnd_profile.value('PROG_APPL_ID'),

2435: releases_rec.shipment_num,
2436: releases_rec.tax_category_id,
2437: v_dflt_tax_category_id,
2438: v_message,
2439: fnd_profile.value('PROG_APPL_ID'),
2440: fnd_profile.value('CONC_PROGRAM_ID'),
2441: fnd_profile.value('CONC_LOGIN_ID'),
2442: fnd_profile.value('CONC_REQUEST_ID'),
2443: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */

Line 2440: fnd_profile.value('CONC_PROGRAM_ID'),

2436: releases_rec.tax_category_id,
2437: v_dflt_tax_category_id,
2438: v_message,
2439: fnd_profile.value('PROG_APPL_ID'),
2440: fnd_profile.value('CONC_PROGRAM_ID'),
2441: fnd_profile.value('CONC_LOGIN_ID'),
2442: fnd_profile.value('CONC_REQUEST_ID'),
2443: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2444: sysdate,

Line 2441: fnd_profile.value('CONC_LOGIN_ID'),

2437: v_dflt_tax_category_id,
2438: v_message,
2439: fnd_profile.value('PROG_APPL_ID'),
2440: fnd_profile.value('CONC_PROGRAM_ID'),
2441: fnd_profile.value('CONC_LOGIN_ID'),
2442: fnd_profile.value('CONC_REQUEST_ID'),
2443: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2444: sysdate,
2445: v_created_by,

Line 2442: fnd_profile.value('CONC_REQUEST_ID'),

2438: v_message,
2439: fnd_profile.value('PROG_APPL_ID'),
2440: fnd_profile.value('CONC_PROGRAM_ID'),
2441: fnd_profile.value('CONC_LOGIN_ID'),
2442: fnd_profile.value('CONC_REQUEST_ID'),
2443: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2444: sysdate,
2445: v_created_by,
2446: sysdate

Line 2534: fnd_profile.value('PROG_APPL_ID'),

2530: reqn_rec.type_lookup_code,
2531: reqn_rec.document_no,
2532: reqn_rec.line_num,
2533: reqn_rec.tax_category_id,
2534: fnd_profile.value('PROG_APPL_ID'),
2535: fnd_profile.value('CONC_PROGRAM_ID'),
2536: fnd_profile.value('CONC_LOGIN_ID'),
2537: fnd_profile.value('CONC_REQUEST_ID'),
2538: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */

Line 2535: fnd_profile.value('CONC_PROGRAM_ID'),

2531: reqn_rec.document_no,
2532: reqn_rec.line_num,
2533: reqn_rec.tax_category_id,
2534: fnd_profile.value('PROG_APPL_ID'),
2535: fnd_profile.value('CONC_PROGRAM_ID'),
2536: fnd_profile.value('CONC_LOGIN_ID'),
2537: fnd_profile.value('CONC_REQUEST_ID'),
2538: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2539: sysdate,

Line 2536: fnd_profile.value('CONC_LOGIN_ID'),

2532: reqn_rec.line_num,
2533: reqn_rec.tax_category_id,
2534: fnd_profile.value('PROG_APPL_ID'),
2535: fnd_profile.value('CONC_PROGRAM_ID'),
2536: fnd_profile.value('CONC_LOGIN_ID'),
2537: fnd_profile.value('CONC_REQUEST_ID'),
2538: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2539: sysdate,
2540: v_created_by,

Line 2537: fnd_profile.value('CONC_REQUEST_ID'),

2533: reqn_rec.tax_category_id,
2534: fnd_profile.value('PROG_APPL_ID'),
2535: fnd_profile.value('CONC_PROGRAM_ID'),
2536: fnd_profile.value('CONC_LOGIN_ID'),
2537: fnd_profile.value('CONC_REQUEST_ID'),
2538: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2539: sysdate,
2540: v_created_by,
2541: sysdate

Line 2997: fnd_profile.value('PROG_APPL_ID'),

2993: reqn_rec.line_num,
2994: reqn_rec.tax_category_id,
2995: v_dflt_tax_category_id,
2996: v_message,
2997: fnd_profile.value('PROG_APPL_ID'),
2998: fnd_profile.value('CONC_PROGRAM_ID'),
2999: fnd_profile.value('CONC_LOGIN_ID'),
3000: fnd_profile.value('CONC_REQUEST_ID'),
3001: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */

Line 2998: fnd_profile.value('CONC_PROGRAM_ID'),

2994: reqn_rec.tax_category_id,
2995: v_dflt_tax_category_id,
2996: v_message,
2997: fnd_profile.value('PROG_APPL_ID'),
2998: fnd_profile.value('CONC_PROGRAM_ID'),
2999: fnd_profile.value('CONC_LOGIN_ID'),
3000: fnd_profile.value('CONC_REQUEST_ID'),
3001: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3002: sysdate,

Line 2999: fnd_profile.value('CONC_LOGIN_ID'),

2995: v_dflt_tax_category_id,
2996: v_message,
2997: fnd_profile.value('PROG_APPL_ID'),
2998: fnd_profile.value('CONC_PROGRAM_ID'),
2999: fnd_profile.value('CONC_LOGIN_ID'),
3000: fnd_profile.value('CONC_REQUEST_ID'),
3001: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3002: sysdate,
3003: v_created_by,

Line 3000: fnd_profile.value('CONC_REQUEST_ID'),

2996: v_message,
2997: fnd_profile.value('PROG_APPL_ID'),
2998: fnd_profile.value('CONC_PROGRAM_ID'),
2999: fnd_profile.value('CONC_LOGIN_ID'),
3000: fnd_profile.value('CONC_REQUEST_ID'),
3001: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3002: sysdate,
3003: v_created_by,
3004: sysdate

Line 3106: fnd_profile.value('PROG_APPL_ID'),

3102: 'SO',
3103: so_rec.document_no,
3104: so_rec.line_number,
3105: so_rec.tax_category_id,
3106: fnd_profile.value('PROG_APPL_ID'),
3107: fnd_profile.value('CONC_PROGRAM_ID'),
3108: fnd_profile.value('CONC_LOGIN_ID'),
3109: fnd_profile.value('CONC_REQUEST_ID'),
3110: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */

Line 3107: fnd_profile.value('CONC_PROGRAM_ID'),

3103: so_rec.document_no,
3104: so_rec.line_number,
3105: so_rec.tax_category_id,
3106: fnd_profile.value('PROG_APPL_ID'),
3107: fnd_profile.value('CONC_PROGRAM_ID'),
3108: fnd_profile.value('CONC_LOGIN_ID'),
3109: fnd_profile.value('CONC_REQUEST_ID'),
3110: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3111: sysdate,

Line 3108: fnd_profile.value('CONC_LOGIN_ID'),

3104: so_rec.line_number,
3105: so_rec.tax_category_id,
3106: fnd_profile.value('PROG_APPL_ID'),
3107: fnd_profile.value('CONC_PROGRAM_ID'),
3108: fnd_profile.value('CONC_LOGIN_ID'),
3109: fnd_profile.value('CONC_REQUEST_ID'),
3110: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3111: sysdate,
3112: v_created_by,

Line 3109: fnd_profile.value('CONC_REQUEST_ID'),

3105: so_rec.tax_category_id,
3106: fnd_profile.value('PROG_APPL_ID'),
3107: fnd_profile.value('CONC_PROGRAM_ID'),
3108: fnd_profile.value('CONC_LOGIN_ID'),
3109: fnd_profile.value('CONC_REQUEST_ID'),
3110: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3111: sysdate,
3112: v_created_by,
3113: sysdate

Line 3533: fnd_profile.value('PROG_APPL_ID'),

3529: so_rec.line_number,
3530: so_rec.tax_category_id,
3531: v_dflt_tax_category_id,
3532: v_message,
3533: fnd_profile.value('PROG_APPL_ID'),
3534: fnd_profile.value('CONC_PROGRAM_ID'),
3535: fnd_profile.value('CONC_LOGIN_ID'),
3536: fnd_profile.value('CONC_REQUEST_ID'),
3537: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */

Line 3534: fnd_profile.value('CONC_PROGRAM_ID'),

3530: so_rec.tax_category_id,
3531: v_dflt_tax_category_id,
3532: v_message,
3533: fnd_profile.value('PROG_APPL_ID'),
3534: fnd_profile.value('CONC_PROGRAM_ID'),
3535: fnd_profile.value('CONC_LOGIN_ID'),
3536: fnd_profile.value('CONC_REQUEST_ID'),
3537: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3538: sysdate,

Line 3535: fnd_profile.value('CONC_LOGIN_ID'),

3531: v_dflt_tax_category_id,
3532: v_message,
3533: fnd_profile.value('PROG_APPL_ID'),
3534: fnd_profile.value('CONC_PROGRAM_ID'),
3535: fnd_profile.value('CONC_LOGIN_ID'),
3536: fnd_profile.value('CONC_REQUEST_ID'),
3537: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3538: sysdate,
3539: v_created_by,

Line 3536: fnd_profile.value('CONC_REQUEST_ID'),

3532: v_message,
3533: fnd_profile.value('PROG_APPL_ID'),
3534: fnd_profile.value('CONC_PROGRAM_ID'),
3535: fnd_profile.value('CONC_LOGIN_ID'),
3536: fnd_profile.value('CONC_REQUEST_ID'),
3537: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3538: sysdate,
3539: v_created_by,
3540: sysdate