DBA Data[Home] [Help]

APPS.BOM_COPY_ROUTING dependencies on FND_GLOBAL

Line 529: fnd_global.conc_request_id,

525: a.attribute12,
526: a.attribute13,
527: a.attribute14,
528: a.attribute15,
529: fnd_global.conc_request_id,
530: NULL,
531: fnd_global.conc_program_id,
532: sysdate,
533: a.operation_type,

Line 531: fnd_global.conc_program_id,

527: a.attribute14,
528: a.attribute15,
529: fnd_global.conc_request_id,
530: NULL,
531: fnd_global.conc_program_id,
532: sysdate,
533: a.operation_type,
534: DECODE (from_org_id, to_org_id, a.reference_flag, 2),
535: -- Bug 3473802

Line 668: fnd_global.conc_request_id,

664: user_id,
665: sysdate,
666: user_id,
667: 'E',
668: fnd_global.conc_request_id,
669: NULL,
670: fnd_global.conc_program_id,
671: sysdate
672: FROM bom_operation_sequences a, -- from op

Line 670: fnd_global.conc_program_id,

666: user_id,
667: 'E',
668: fnd_global.conc_request_id,
669: NULL,
670: fnd_global.conc_program_id,
671: sysdate
672: FROM bom_operation_sequences a, -- from op
673: bom_departments b, -- from op's dept
674: bom_departments c -- to op's dept

Line 736: fnd_global.conc_request_id,

732: user_id,
733: sysdate,
734: user_id,
735: 'E',
736: fnd_global.conc_request_id,
737: NULL,
738: fnd_global.conc_program_id,
739: sysdate
740: FROM bom_operation_sequences a, -- from op

Line 738: fnd_global.conc_program_id,

734: user_id,
735: 'E',
736: fnd_global.conc_request_id,
737: NULL,
738: fnd_global.conc_program_id,
739: sysdate
740: FROM bom_operation_sequences a, -- from op
741: bom_departments b, -- from op's dept
742: bom_departments c -- to op's dept

Line 820: fnd_global.conc_request_id,

816: user_id,
817: sysdate,
818: user_id,
819: 'E',
820: fnd_global.conc_request_id,
821: NULL,
822: fnd_global.conc_program_id,
823: sysdate
824: FROM bom_operation_sequences a

Line 822: fnd_global.conc_program_id,

818: user_id,
819: 'E',
820: fnd_global.conc_request_id,
821: NULL,
822: fnd_global.conc_program_id,
823: sysdate
824: FROM bom_operation_sequences a
825: WHERE a.routing_sequence_id = x_from_sequence_id
826: AND (display_option = 1 /* ALL */

Line 898: fnd_global.conc_request_id,

894: user_id,
895: sysdate,
896: user_id,
897: 'E',
898: fnd_global.conc_request_id,
899: NULL,
900: fnd_global.conc_program_id,
901: sysdate
902: FROM bom_operation_sequences a

Line 900: fnd_global.conc_program_id,

896: user_id,
897: 'E',
898: fnd_global.conc_request_id,
899: NULL,
900: fnd_global.conc_program_id,
901: sysdate
902: FROM bom_operation_sequences a
903: WHERE a.routing_sequence_id = x_from_sequence_id
904: AND (display_option = 1 /* ALL */

Line 1128: fnd_global.conc_request_id,

1124: bon.attribute12,
1125: bon.attribute13,
1126: bon.attribute14,
1127: bon.attribute15,
1128: fnd_global.conc_request_id,
1129: NULL,
1130: fnd_global.conc_program_id,
1131: sysdate
1132: FROM bom_operation_networks bon,

Line 1130: fnd_global.conc_program_id,

1126: bon.attribute14,
1127: bon.attribute15,
1128: fnd_global.conc_request_id,
1129: NULL,
1130: fnd_global.conc_program_id,
1131: sysdate
1132: FROM bom_operation_networks bon,
1133: bom_operation_sequences bos4, -- dest to op
1134: bom_operation_sequences bos3, -- dest from op

Line 1215: fnd_global.conc_request_id,

1211: user_id,
1212: sysdate,
1213: user_id,
1214: 'E',
1215: fnd_global.conc_request_id,
1216: NULL,
1217: fnd_global.conc_program_id,
1218: sysdate
1219: FROM bom_operation_networks bon,

Line 1217: fnd_global.conc_program_id,

1213: user_id,
1214: 'E',
1215: fnd_global.conc_request_id,
1216: NULL,
1217: fnd_global.conc_program_id,
1218: sysdate
1219: FROM bom_operation_networks bon,
1220: bom_operation_sequences bos4, -- dest to op
1221: bom_operation_sequences bos3, -- dest from op

Line 1257: fnd_global.conc_request_id,

1253: user_id,
1254: sysdate,
1255: user_id,
1256: 'E',
1257: fnd_global.conc_request_id,
1258: NULL,
1259: fnd_global.conc_program_id,
1260: sysdate
1261: FROM bom_operation_networks bon,

Line 1259: fnd_global.conc_program_id,

1255: user_id,
1256: 'E',
1257: fnd_global.conc_request_id,
1258: NULL,
1259: fnd_global.conc_program_id,
1260: sysdate
1261: FROM bom_operation_networks bon,
1262: bom_operation_sequences bos4, -- dest to op
1263: bom_operation_sequences bos3, -- dest from op

Line 1316: fnd_global.conc_request_id,

1312: user_id,
1313: sysdate,
1314: user_id,
1315: 'E',
1316: fnd_global.conc_request_id,
1317: NULL,
1318: fnd_global.conc_program_id,
1319: sysdate
1320: FROM bom_operation_networks bon,

Line 1318: fnd_global.conc_program_id,

1314: user_id,
1315: 'E',
1316: fnd_global.conc_request_id,
1317: NULL,
1318: fnd_global.conc_program_id,
1319: sysdate
1320: FROM bom_operation_networks bon,
1321: bom_operation_sequences bos4, -- dest to op
1322: bom_operation_sequences bos3, -- dest from op

Line 1358: fnd_global.conc_request_id,

1354: user_id,
1355: sysdate,
1356: user_id,
1357: 'E',
1358: fnd_global.conc_request_id,
1359: NULL,
1360: fnd_global.conc_program_id,
1361: sysdate
1362: FROM bom_operation_networks bon,

Line 1360: fnd_global.conc_program_id,

1356: user_id,
1357: 'E',
1358: fnd_global.conc_request_id,
1359: NULL,
1360: fnd_global.conc_program_id,
1361: sysdate
1362: FROM bom_operation_networks bon,
1363: bom_operation_sequences bos4, -- dest to op
1364: bom_operation_sequences bos3, -- dest from op

Line 1412: x_program_id => fnd_global.conc_program_id,

1408: x_to_pk5_value => '',
1409: x_created_by => user_id,
1410: x_last_update_login => '',
1411: x_program_application_id => '',
1412: x_program_id => fnd_global.conc_program_id,
1413: x_request_id => fnd_global.conc_request_id
1414: );
1415: sql_stmt_num := 301;
1416: END LOOP;

Line 1413: x_request_id => fnd_global.conc_request_id

1409: x_created_by => user_id,
1410: x_last_update_login => '',
1411: x_program_application_id => '',
1412: x_program_id => fnd_global.conc_program_id,
1413: x_request_id => fnd_global.conc_request_id
1414: );
1415: sql_stmt_num := 301;
1416: END LOOP;
1417:

Line 1439: x_program_id => fnd_global.conc_program_id,

1435: x_to_pk5_value => '',
1436: x_created_by => user_id,
1437: x_last_update_login => '',
1438: x_program_application_id => '',
1439: x_program_id => fnd_global.conc_program_id,
1440: x_request_id => fnd_global.conc_request_id
1441: );
1442: --end bug fix 3473851
1443:

Line 1440: x_request_id => fnd_global.conc_request_id

1436: x_created_by => user_id,
1437: x_last_update_login => '',
1438: x_program_application_id => '',
1439: x_program_id => fnd_global.conc_program_id,
1440: x_request_id => fnd_global.conc_request_id
1441: );
1442: --end bug fix 3473851
1443:
1444: --INSERT OPERATION RESOURCES

Line 1531: fnd_global.conc_request_id,

1527: b.attribute12,
1528: b.attribute13,
1529: b.attribute14,
1530: b.attribute15,
1531: fnd_global.conc_request_id,
1532: NULL,
1533: fnd_global.conc_program_id,
1534: sysdate,
1535: b.schedule_seq_num,

Line 1533: fnd_global.conc_program_id,

1529: b.attribute14,
1530: b.attribute15,
1531: fnd_global.conc_request_id,
1532: NULL,
1533: fnd_global.conc_program_id,
1534: sysdate,
1535: b.schedule_seq_num,
1536: b.substitute_group_num,
1537: b.principle_flag,

Line 1589: fnd_global.conc_request_id,

1585: user_id,
1586: sysdate,
1587: user_id,
1588: 'E',
1589: fnd_global.conc_request_id,
1590: NULL,
1591: fnd_global.conc_program_id,
1592: sysdate
1593: FROM bom_operation_sequences a,

Line 1591: fnd_global.conc_program_id,

1587: user_id,
1588: 'E',
1589: fnd_global.conc_request_id,
1590: NULL,
1591: fnd_global.conc_program_id,
1592: sysdate
1593: FROM bom_operation_sequences a,
1594: bom_operation_resources b,
1595: bom_operation_sequences fbor,

Line 1619: fnd_global.conc_request_id,

1615: user_id,
1616: sysdate,
1617: user_id,
1618: 'E',
1619: fnd_global.conc_request_id,
1620: NULL,
1621: fnd_global.conc_program_id,
1622: sysdate
1623: FROM bom_operation_sequences a,

Line 1621: fnd_global.conc_program_id,

1617: user_id,
1618: 'E',
1619: fnd_global.conc_request_id,
1620: NULL,
1621: fnd_global.conc_program_id,
1622: sysdate
1623: FROM bom_operation_sequences a,
1624: bom_operation_resources b,
1625: bom_operation_sequences fbor,

Line 1759: fnd_global.conc_request_id,

1755: NULL,
1756: b.resource_offset_percent,
1757: b.autocharge_type,
1758: b.attribute_category,
1759: fnd_global.conc_request_id,
1760: NULL,
1761: fnd_global.conc_program_id,
1762: sysdate,
1763: b.attribute1,

Line 1761: fnd_global.conc_program_id,

1757: b.autocharge_type,
1758: b.attribute_category,
1759: fnd_global.conc_request_id,
1760: NULL,
1761: fnd_global.conc_program_id,
1762: sysdate,
1763: b.attribute1,
1764: b.attribute2,
1765: b.attribute3,

Line 1832: fnd_global.conc_request_id,

1828: user_id,
1829: sysdate,
1830: user_id,
1831: 'E',
1832: fnd_global.conc_request_id,
1833: NULL,
1834: fnd_global.conc_program_id,
1835: sysdate
1836: FROM bom_operation_resources a,

Line 1834: fnd_global.conc_program_id,

1830: user_id,
1831: 'E',
1832: fnd_global.conc_request_id,
1833: NULL,
1834: fnd_global.conc_program_id,
1835: sysdate
1836: FROM bom_operation_resources a,
1837: bom_operation_sequences fbor,
1838: bom_sub_operation_resources b,

Line 1862: fnd_global.conc_request_id,

1858: user_id,
1859: sysdate,
1860: user_id,
1861: 'E',
1862: fnd_global.conc_request_id,
1863: NULL,
1864: fnd_global.conc_program_id,
1865: sysdate
1866: FROM bom_operation_resources a,

Line 1864: fnd_global.conc_program_id,

1860: user_id,
1861: 'E',
1862: fnd_global.conc_request_id,
1863: NULL,
1864: fnd_global.conc_program_id,
1865: sysdate
1866: FROM bom_operation_resources a,
1867: bom_operation_sequences fbor,
1868: bom_sub_operation_resources b,

Line 2515: fnd_global.conc_request_id,

2511: a.attribute12,
2512: a.attribute13,
2513: a.attribute14,
2514: a.attribute15,
2515: fnd_global.conc_request_id,
2516: NULL,
2517: fnd_global.conc_program_id,
2518: sysdate,
2519: a.operation_type,

Line 2517: fnd_global.conc_program_id,

2513: a.attribute14,
2514: a.attribute15,
2515: fnd_global.conc_request_id,
2516: NULL,
2517: fnd_global.conc_program_id,
2518: sysdate,
2519: a.operation_type,
2520: DECODE (from_org_id, to_org_id, a.reference_flag, 2),
2521: -- Bug 3473802

Line 2629: fnd_global.conc_request_id,

2625: user_id,
2626: sysdate,
2627: user_id,
2628: 'E',
2629: fnd_global.conc_request_id,
2630: NULL,
2631: fnd_global.conc_program_id,
2632: sysdate
2633: FROM bom_operation_sequences a, -- from op

Line 2631: fnd_global.conc_program_id,

2627: user_id,
2628: 'E',
2629: fnd_global.conc_request_id,
2630: NULL,
2631: fnd_global.conc_program_id,
2632: sysdate
2633: FROM bom_operation_sequences a, -- from op
2634: bom_departments b, -- from op's dept
2635: bom_departments c -- to op's dept

Line 2677: fnd_global.conc_request_id,

2673: user_id,
2674: sysdate,
2675: user_id,
2676: 'E',
2677: fnd_global.conc_request_id,
2678: NULL,
2679: fnd_global.conc_program_id,
2680: sysdate
2681: FROM bom_operation_sequences a, -- from op

Line 2679: fnd_global.conc_program_id,

2675: user_id,
2676: 'E',
2677: fnd_global.conc_request_id,
2678: NULL,
2679: fnd_global.conc_program_id,
2680: sysdate
2681: FROM bom_operation_sequences a, -- from op
2682: bom_departments b -- from op's dept
2683: WHERE a.routing_sequence_id = x_from_sequence_id

Line 2736: fnd_global.conc_request_id,

2732: user_id,
2733: sysdate,
2734: user_id,
2735: 'E',
2736: fnd_global.conc_request_id,
2737: NULL,
2738: fnd_global.conc_program_id,
2739: sysdate
2740: FROM bom_operation_sequences a

Line 2738: fnd_global.conc_program_id,

2734: user_id,
2735: 'E',
2736: fnd_global.conc_request_id,
2737: NULL,
2738: fnd_global.conc_program_id,
2739: sysdate
2740: FROM bom_operation_sequences a
2741: WHERE a.routing_sequence_id = x_from_sequence_id
2742: AND ( ( p_cpy_disable_fields = 'Y' AND a.effectivity_date <= rev_date) -- For first revised item we can have past eff comps as eff on the target date

Line 2795: fnd_global.conc_request_id,

2791: user_id,
2792: sysdate,
2793: user_id,
2794: 'E',
2795: fnd_global.conc_request_id,
2796: NULL,
2797: fnd_global.conc_program_id,
2798: sysdate
2799: FROM bom_operation_sequences a

Line 2797: fnd_global.conc_program_id,

2793: user_id,
2794: 'E',
2795: fnd_global.conc_request_id,
2796: NULL,
2797: fnd_global.conc_program_id,
2798: sysdate
2799: FROM bom_operation_sequences a
2800: WHERE a.routing_sequence_id = x_from_sequence_id
2801: AND ( ( p_cpy_disable_fields = 'Y' AND a.effectivity_date <= rev_date) -- For first revised item we can have past eff comps as eff on the target date

Line 3005: fnd_global.conc_request_id,

3001: bon.attribute12,
3002: bon.attribute13,
3003: bon.attribute14,
3004: bon.attribute15,
3005: fnd_global.conc_request_id,
3006: NULL,
3007: fnd_global.conc_program_id,
3008: sysdate
3009: FROM bom_operation_networks bon,

Line 3007: fnd_global.conc_program_id,

3003: bon.attribute14,
3004: bon.attribute15,
3005: fnd_global.conc_request_id,
3006: NULL,
3007: fnd_global.conc_program_id,
3008: sysdate
3009: FROM bom_operation_networks bon,
3010: bom_operation_sequences bos4, -- dest to op
3011: bom_operation_sequences bos3, -- dest from op

Line 3093: fnd_global.conc_request_id,

3089: user_id,
3090: sysdate,
3091: user_id,
3092: 'E',
3093: fnd_global.conc_request_id,
3094: NULL,
3095: fnd_global.conc_program_id,
3096: sysdate
3097: FROM bom_operation_networks bon,

Line 3095: fnd_global.conc_program_id,

3091: user_id,
3092: 'E',
3093: fnd_global.conc_request_id,
3094: NULL,
3095: fnd_global.conc_program_id,
3096: sysdate
3097: FROM bom_operation_networks bon,
3098: bom_operation_sequences bos4, -- dest to op
3099: bom_operation_sequences bos3, -- dest from op

Line 3136: fnd_global.conc_request_id,

3132: user_id,
3133: sysdate,
3134: user_id,
3135: 'E',
3136: fnd_global.conc_request_id,
3137: NULL,
3138: fnd_global.conc_program_id,
3139: sysdate
3140: FROM bom_operation_networks bon,

Line 3138: fnd_global.conc_program_id,

3134: user_id,
3135: 'E',
3136: fnd_global.conc_request_id,
3137: NULL,
3138: fnd_global.conc_program_id,
3139: sysdate
3140: FROM bom_operation_networks bon,
3141: bom_operation_sequences bos4, -- dest to op
3142: bom_operation_sequences bos3, -- dest from op

Line 3196: fnd_global.conc_request_id,

3192: user_id,
3193: sysdate,
3194: user_id,
3195: 'E',
3196: fnd_global.conc_request_id,
3197: NULL,
3198: fnd_global.conc_program_id,
3199: sysdate
3200: FROM bom_operation_networks bon,

Line 3198: fnd_global.conc_program_id,

3194: user_id,
3195: 'E',
3196: fnd_global.conc_request_id,
3197: NULL,
3198: fnd_global.conc_program_id,
3199: sysdate
3200: FROM bom_operation_networks bon,
3201: bom_operation_sequences bos4, -- dest to op
3202: bom_operation_sequences bos3, -- dest from op

Line 3239: fnd_global.conc_request_id,

3235: user_id,
3236: sysdate,
3237: user_id,
3238: 'E',
3239: fnd_global.conc_request_id,
3240: NULL,
3241: fnd_global.conc_program_id,
3242: sysdate
3243: FROM bom_operation_networks bon,

Line 3241: fnd_global.conc_program_id,

3237: user_id,
3238: 'E',
3239: fnd_global.conc_request_id,
3240: NULL,
3241: fnd_global.conc_program_id,
3242: sysdate
3243: FROM bom_operation_networks bon,
3244: bom_operation_sequences bos4, -- dest to op
3245: bom_operation_sequences bos3, -- dest from op

Line 3360: fnd_global.conc_request_id,

3356: b.attribute12,
3357: b.attribute13,
3358: b.attribute14,
3359: b.attribute15,
3360: fnd_global.conc_request_id,
3361: NULL,
3362: fnd_global.conc_program_id,
3363: sysdate,
3364: b.schedule_seq_num,

Line 3362: fnd_global.conc_program_id,

3358: b.attribute14,
3359: b.attribute15,
3360: fnd_global.conc_request_id,
3361: NULL,
3362: fnd_global.conc_program_id,
3363: sysdate,
3364: b.schedule_seq_num,
3365: b.substitute_group_num,
3366: b.principle_flag,

Line 3419: fnd_global.conc_request_id,

3415: user_id,
3416: sysdate,
3417: user_id,
3418: 'E',
3419: fnd_global.conc_request_id,
3420: NULL,
3421: fnd_global.conc_program_id,
3422: sysdate
3423: FROM bom_operation_sequences a,

Line 3421: fnd_global.conc_program_id,

3417: user_id,
3418: 'E',
3419: fnd_global.conc_request_id,
3420: NULL,
3421: fnd_global.conc_program_id,
3422: sysdate
3423: FROM bom_operation_sequences a,
3424: bom_operation_resources b,
3425: bom_operation_sequences fbor,

Line 3450: fnd_global.conc_request_id,

3446: user_id,
3447: sysdate,
3448: user_id,
3449: 'E',
3450: fnd_global.conc_request_id,
3451: NULL,
3452: fnd_global.conc_program_id,
3453: sysdate
3454: FROM bom_operation_sequences a,

Line 3452: fnd_global.conc_program_id,

3448: user_id,
3449: 'E',
3450: fnd_global.conc_request_id,
3451: NULL,
3452: fnd_global.conc_program_id,
3453: sysdate
3454: FROM bom_operation_sequences a,
3455: bom_operation_resources b,
3456: bom_operation_sequences fbor,

Line 3590: fnd_global.conc_request_id,

3586: NULL,
3587: b.resource_offset_percent,
3588: b.autocharge_type,
3589: b.attribute_category,
3590: fnd_global.conc_request_id,
3591: NULL,
3592: fnd_global.conc_program_id,
3593: sysdate,
3594: b.attribute1,

Line 3592: fnd_global.conc_program_id,

3588: b.autocharge_type,
3589: b.attribute_category,
3590: fnd_global.conc_request_id,
3591: NULL,
3592: fnd_global.conc_program_id,
3593: sysdate,
3594: b.attribute1,
3595: b.attribute2,
3596: b.attribute3,

Line 3664: fnd_global.conc_request_id,

3660: user_id,
3661: sysdate,
3662: user_id,
3663: 'E',
3664: fnd_global.conc_request_id,
3665: NULL,
3666: fnd_global.conc_program_id,
3667: sysdate
3668: FROM bom_operation_resources a,

Line 3666: fnd_global.conc_program_id,

3662: user_id,
3663: 'E',
3664: fnd_global.conc_request_id,
3665: NULL,
3666: fnd_global.conc_program_id,
3667: sysdate
3668: FROM bom_operation_resources a,
3669: bom_operation_sequences fbor,
3670: bom_sub_operation_resources b,

Line 3695: fnd_global.conc_request_id,

3691: user_id,
3692: sysdate,
3693: user_id,
3694: 'E',
3695: fnd_global.conc_request_id,
3696: NULL,
3697: fnd_global.conc_program_id,
3698: sysdate
3699: FROM bom_operation_resources a,

Line 3697: fnd_global.conc_program_id,

3693: user_id,
3694: 'E',
3695: fnd_global.conc_request_id,
3696: NULL,
3697: fnd_global.conc_program_id,
3698: sysdate
3699: FROM bom_operation_resources a,
3700: bom_operation_sequences fbor,
3701: bom_sub_operation_resources b,

Line 3864: x_program_id => fnd_global.conc_program_id,

3860: x_to_pk5_value => '',
3861: x_created_by => p_user_id,
3862: x_last_update_login => '',
3863: x_program_application_id => '',
3864: x_program_id => fnd_global.conc_program_id,
3865: x_request_id => fnd_global.conc_request_id
3866: );
3867: END LOOP;
3868:

Line 3865: x_request_id => fnd_global.conc_request_id

3861: x_created_by => p_user_id,
3862: x_last_update_login => '',
3863: x_program_application_id => '',
3864: x_program_id => fnd_global.conc_program_id,
3865: x_request_id => fnd_global.conc_request_id
3866: );
3867: END LOOP;
3868:
3869: END;

Line 3888: x_program_id => fnd_global.conc_program_id,

3884: x_to_pk5_value => '',
3885: x_created_by => p_user_id,
3886: x_last_update_login => '',
3887: x_program_application_id => '',
3888: x_program_id => fnd_global.conc_program_id,
3889: x_request_id => fnd_global.conc_request_id
3890: );
3891: --end bug fix 3473851
3892: END copy_attachments;

Line 3889: x_request_id => fnd_global.conc_request_id

3885: x_created_by => p_user_id,
3886: x_last_update_login => '',
3887: x_program_application_id => '',
3888: x_program_id => fnd_global.conc_program_id,
3889: x_request_id => fnd_global.conc_request_id
3890: );
3891: --end bug fix 3473851
3892: END copy_attachments;
3893: