DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on FND_GLOBAL

Line 1433: fnd_global.conc_request_id,

1429: user_id,
1430: SYSDATE,
1431: user_id,
1432: 'E',
1433: fnd_global.conc_request_id,
1434: NULL,
1435: fnd_global.conc_program_id,
1436: sysdate
1437: FROM dual;

Line 1435: fnd_global.conc_program_id,

1431: user_id,
1432: 'E',
1433: fnd_global.conc_request_id,
1434: NULL,
1435: fnd_global.conc_program_id,
1436: sysdate
1437: FROM dual;
1438: l_msg_count := l_error_msg_tbl.next(l_msg_count);
1439: END LOOP;

Line 1572: fnd_global.conc_request_id,

1568: NULL, NULL,
1569: bom_inventory_components_s.CURRVAL
1570: ),
1571: to_sequence_id,
1572: fnd_global.conc_request_id,
1573: NULL,
1574: fnd_global.conc_program_id,
1575: sysdate,
1576: bic.wip_supply_type,

Line 1574: fnd_global.conc_program_id,

1570: ),
1571: to_sequence_id,
1572: fnd_global.conc_request_id,
1573: NULL,
1574: fnd_global.conc_program_id,
1575: sysdate,
1576: bic.wip_supply_type,
1577: DECODE (rto_flag, 'Y', 2, bic.pick_components),
1578: DECODE (x_from_org_id,

Line 1969: fnd_global.conc_request_id,

1965: NULL, NULL,
1966: bom_inventory_components_s.CURRVAL
1967: ),
1968: to_sequence_id,
1969: fnd_global.conc_request_id,
1970: NULL,
1971: fnd_global.conc_program_id,
1972: sysdate,
1973: bic.wip_supply_type,

Line 1971: fnd_global.conc_program_id,

1967: ),
1968: to_sequence_id,
1969: fnd_global.conc_request_id,
1970: NULL,
1971: fnd_global.conc_program_id,
1972: sysdate,
1973: bic.wip_supply_type,
1974: DECODE (rto_flag, 'Y', 2, bic.pick_components),
1975: DECODE (x_from_org_id,

Line 2370: fnd_global.conc_request_id,

2366: NULL, NULL,
2367: bom_inventory_components_s.CURRVAL
2368: ),
2369: to_sequence_id,
2370: fnd_global.conc_request_id,
2371: NULL,
2372: fnd_global.conc_program_id,
2373: sysdate,
2374: bic.wip_supply_type,

Line 2372: fnd_global.conc_program_id,

2368: ),
2369: to_sequence_id,
2370: fnd_global.conc_request_id,
2371: NULL,
2372: fnd_global.conc_program_id,
2373: sysdate,
2374: bic.wip_supply_type,
2375: DECODE (rto_flag, 'Y', 2, bic.pick_components),
2376: DECODE (x_from_org_id,

Line 2845: fnd_global.conc_request_id,

2841: NULL, NULL,
2842: bom_inventory_components_s.CURRVAL
2843: ),
2844: to_sequence_id,
2845: fnd_global.conc_request_id,
2846: NULL,
2847: fnd_global.conc_program_id,
2848: sysdate,
2849: bic.wip_supply_type,

Line 2847: fnd_global.conc_program_id,

2843: ),
2844: to_sequence_id,
2845: fnd_global.conc_request_id,
2846: NULL,
2847: fnd_global.conc_program_id,
2848: sysdate,
2849: bic.wip_supply_type,
2850: DECODE (rto_flag, 'Y', 2, bic.pick_components),
2851: DECODE (x_from_org_id,

Line 3288: fnd_global.conc_request_id,

3284: NULL, NULL,
3285: bom_inventory_components_s.CURRVAL
3286: ),
3287: to_sequence_id,
3288: fnd_global.conc_request_id,
3289: NULL,
3290: fnd_global.conc_program_id,
3291: sysdate,
3292: bic.wip_supply_type,

Line 3290: fnd_global.conc_program_id,

3286: ),
3287: to_sequence_id,
3288: fnd_global.conc_request_id,
3289: NULL,
3290: fnd_global.conc_program_id,
3291: sysdate,
3292: bic.wip_supply_type,
3293: DECODE (rto_flag, 'Y', 2, bic.pick_components),
3294: DECODE (x_from_org_id,

Line 3778: fnd_global.conc_request_id,

3774: user_id,
3775: SYSDATE,
3776: user_id,
3777: 'E',
3778: fnd_global.conc_request_id,
3779: NULL,
3780: fnd_global.conc_program_id,
3781: sysdate
3782: FROM bom_components_b bcb

Line 3780: fnd_global.conc_program_id,

3776: user_id,
3777: 'E',
3778: fnd_global.conc_request_id,
3779: NULL,
3780: fnd_global.conc_program_id,
3781: sysdate
3782: FROM bom_components_b bcb
3783: WHERE bcb.component_sequence_id = l_from_comps(l_index);
3784: l_msg_count := l_error_msg_tbl.next(l_msg_count);

Line 3900: fnd_global.conc_request_id,

3896: user_id,
3897: SYSDATE,
3898: user_id,
3899: 'E',
3900: fnd_global.conc_request_id,
3901: NULL,
3902: fnd_global.conc_program_id,
3903: sysdate
3904: FROM mtl_system_items_b_kfv msbk1

Line 3902: fnd_global.conc_program_id,

3898: user_id,
3899: 'E',
3900: fnd_global.conc_request_id,
3901: NULL,
3902: fnd_global.conc_program_id,
3903: sysdate
3904: FROM mtl_system_items_b_kfv msbk1
3905: WHERE msbk1.inventory_item_id = from_item_id
3906: AND msbk1.organization_id = from_org_id;

Line 3997: fnd_global.conc_request_id,

3993: user_id,
3994: SYSDATE,
3995: user_id,
3996: 'E',
3997: fnd_global.conc_request_id,
3998: NULL,
3999: fnd_global.conc_program_id,
4000: sysdate
4001: FROM mtl_system_items_b_kfv msbk1

Line 3999: fnd_global.conc_program_id,

3995: user_id,
3996: 'E',
3997: fnd_global.conc_request_id,
3998: NULL,
3999: fnd_global.conc_program_id,
4000: sysdate
4001: FROM mtl_system_items_b_kfv msbk1
4002: WHERE msbk1.inventory_item_id = from_item_id
4003: AND msbk1.organization_id = from_org_id;

Line 4044: fnd_global.conc_request_id,

4040: user_id,
4041: SYSDATE,
4042: user_id,
4043: 'E',
4044: fnd_global.conc_request_id,
4045: NULL,
4046: fnd_global.conc_program_id,
4047: sysdate
4048: FROM bom_components_b bcb,

Line 4046: fnd_global.conc_program_id,

4042: user_id,
4043: 'E',
4044: fnd_global.conc_request_id,
4045: NULL,
4046: fnd_global.conc_program_id,
4047: sysdate
4048: FROM bom_components_b bcb,
4049: mtl_system_items_b msib, -- component
4050: bom_copy_explosions_v bev

Line 4133: fnd_global.conc_request_id,

4129: user_id,
4130: SYSDATE,
4131: user_id,
4132: 'E',
4133: fnd_global.conc_request_id,
4134: NULL,
4135: fnd_global.conc_program_id,
4136: sysdate
4137: FROM bom_components_b bcb,

Line 4135: fnd_global.conc_program_id,

4131: user_id,
4132: 'E',
4133: fnd_global.conc_request_id,
4134: NULL,
4135: fnd_global.conc_program_id,
4136: sysdate
4137: FROM bom_components_b bcb,
4138: bom_copy_explosions_v bev
4139: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 4272: fnd_global.conc_request_id,

4268: user_id,
4269: SYSDATE,
4270: user_id,
4271: 'E',
4272: fnd_global.conc_request_id,
4273: NULL,
4274: fnd_global.conc_program_id,
4275: sysdate
4276: FROM bom_components_b bcb,

Line 4274: fnd_global.conc_program_id,

4270: user_id,
4271: 'E',
4272: fnd_global.conc_request_id,
4273: NULL,
4274: fnd_global.conc_program_id,
4275: sysdate
4276: FROM bom_components_b bcb,
4277: mtl_system_items_b msib,
4278: bom_copy_explosions_v bev

Line 4359: fnd_global.conc_request_id,

4355: user_id,
4356: SYSDATE,
4357: user_id,
4358: 'E',
4359: fnd_global.conc_request_id,
4360: NULL,
4361: fnd_global.conc_program_id,
4362: sysdate
4363: FROM bom_components_b bcb,

Line 4361: fnd_global.conc_program_id,

4357: user_id,
4358: 'E',
4359: fnd_global.conc_request_id,
4360: NULL,
4361: fnd_global.conc_program_id,
4362: sysdate
4363: FROM bom_components_b bcb,
4364: bom_copy_explosions_v bev
4365: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 4455: fnd_global.conc_request_id,

4451: user_id,
4452: SYSDATE,
4453: user_id,
4454: 'E',
4455: fnd_global.conc_request_id,
4456: NULL,
4457: fnd_global.conc_program_id,
4458: sysdate
4459: FROM bom_components_b bcb,

Line 4457: fnd_global.conc_program_id,

4453: user_id,
4454: 'E',
4455: fnd_global.conc_request_id,
4456: NULL,
4457: fnd_global.conc_program_id,
4458: sysdate
4459: FROM bom_components_b bcb,
4460: mtl_system_items_b msib
4461: WHERE bcb.bill_sequence_id = to_sequence_id

Line 4520: fnd_global.conc_request_id,

4516: user_id,
4517: SYSDATE,
4518: user_id,
4519: 'E',
4520: fnd_global.conc_request_id,
4521: NULL,
4522: fnd_global.conc_program_id,
4523: sysdate
4524: FROM bom_components_b bcb,

Line 4522: fnd_global.conc_program_id,

4518: user_id,
4519: 'E',
4520: fnd_global.conc_request_id,
4521: NULL,
4522: fnd_global.conc_program_id,
4523: sysdate
4524: FROM bom_components_b bcb,
4525: mtl_system_items_b msib
4526: WHERE bcb.bill_sequence_id = to_sequence_id

Line 4594: fnd_global.conc_request_id,

4590: user_id,
4591: SYSDATE,
4592: user_id,
4593: 'E',
4594: fnd_global.conc_request_id,
4595: NULL,
4596: fnd_global.conc_program_id,
4597: sysdate
4598: FROM bom_components_b bcb,

Line 4596: fnd_global.conc_program_id,

4592: user_id,
4593: 'E',
4594: fnd_global.conc_request_id,
4595: NULL,
4596: fnd_global.conc_program_id,
4597: sysdate
4598: FROM bom_components_b bcb,
4599: bom_copy_explosions_v bev
4600: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 4777: fnd_global.conc_request_id,

4773: NULL, NULL,
4774: bom_inventory_components_s.CURRVAL
4775: ),
4776: to_sequence_id,
4777: fnd_global.conc_request_id,
4778: NULL,
4779: fnd_global.conc_program_id,
4780: sysdate,
4781: bic.wip_supply_type,

Line 4779: fnd_global.conc_program_id,

4775: ),
4776: to_sequence_id,
4777: fnd_global.conc_request_id,
4778: NULL,
4779: fnd_global.conc_program_id,
4780: sysdate,
4781: bic.wip_supply_type,
4782: DECODE (rto_flag, 'Y', 2, pick_components),
4783: DECODE (x_from_org_id,

Line 5228: fnd_global.conc_request_id,

5224: user_id,
5225: SYSDATE,
5226: user_id,
5227: 'E',
5228: fnd_global.conc_request_id,
5229: NULL,
5230: fnd_global.conc_program_id,
5231: sysdate
5232: FROM bom_components_b bcb,

Line 5230: fnd_global.conc_program_id,

5226: user_id,
5227: 'E',
5228: fnd_global.conc_request_id,
5229: NULL,
5230: fnd_global.conc_program_id,
5231: sysdate
5232: FROM bom_components_b bcb,
5233: mtl_system_items_b msib1,
5234: mtl_system_items_b msib2

Line 5281: fnd_global.conc_request_id,

5277: user_id,
5278: SYSDATE,
5279: user_id,
5280: 'E',
5281: fnd_global.conc_request_id,
5282: NULL,
5283: fnd_global.conc_program_id,
5284: sysdate
5285: FROM bom_components_b bcb,

Line 5283: fnd_global.conc_program_id,

5279: user_id,
5280: 'E',
5281: fnd_global.conc_request_id,
5282: NULL,
5283: fnd_global.conc_program_id,
5284: sysdate
5285: FROM bom_components_b bcb,
5286: mtl_system_items_b msib1,
5287: mtl_system_items_b msib2

Line 5338: fnd_global.conc_request_id,

5334: user_id,
5335: SYSDATE,
5336: user_id,
5337: 'E',
5338: fnd_global.conc_request_id,
5339: NULL,
5340: fnd_global.conc_program_id,
5341: sysdate
5342: FROM bom_components_b bcb,

Line 5340: fnd_global.conc_program_id,

5336: user_id,
5337: 'E',
5338: fnd_global.conc_request_id,
5339: NULL,
5340: fnd_global.conc_program_id,
5341: sysdate
5342: FROM bom_components_b bcb,
5343: mtl_system_items_b msib1, -- Comp
5344: mtl_system_items_b msib2 -- Structure

Line 5392: fnd_global.conc_request_id,

5388: user_id,
5389: SYSDATE,
5390: user_id,
5391: 'E',
5392: fnd_global.conc_request_id,
5393: NULL,
5394: fnd_global.conc_program_id,
5395: sysdate
5396: FROM bom_components_b bcb,

Line 5394: fnd_global.conc_program_id,

5390: user_id,
5391: 'E',
5392: fnd_global.conc_request_id,
5393: NULL,
5394: fnd_global.conc_program_id,
5395: sysdate
5396: FROM bom_components_b bcb,
5397: mtl_system_items_b msib1, -- Comp
5398: mtl_system_items_b msib2 -- Structure

Line 5449: fnd_global.conc_request_id,

5445: user_id,
5446: SYSDATE,
5447: user_id,
5448: 'E',
5449: fnd_global.conc_request_id,
5450: NULL,
5451: fnd_global.conc_program_id,
5452: sysdate
5453: FROM bom_components_b bcb,

Line 5451: fnd_global.conc_program_id,

5447: user_id,
5448: 'E',
5449: fnd_global.conc_request_id,
5450: NULL,
5451: fnd_global.conc_program_id,
5452: sysdate
5453: FROM bom_components_b bcb,
5454: mtl_system_items_b msib1, -- Comp
5455: mtl_system_items_b msib2 -- Structure

Line 5610: fnd_global.conc_request_id,

5606: ref_designator_comment,
5607: x_e_change_notice,
5608: bic.component_sequence_id,
5609: x_acd_type,
5610: fnd_global.conc_request_id,
5611: NULL,
5612: fnd_global.conc_program_id,
5613: sysdate,
5614: brd.attribute_category,

Line 5612: fnd_global.conc_program_id,

5608: bic.component_sequence_id,
5609: x_acd_type,
5610: fnd_global.conc_request_id,
5611: NULL,
5612: fnd_global.conc_program_id,
5613: sysdate,
5614: brd.attribute_category,
5615: brd.attribute1,
5616: brd.attribute2,

Line 5687: fnd_global.conc_request_id,

5683: ref_designator_comment,
5684: x_e_change_notice,
5685: bic.component_sequence_id,
5686: x_acd_type,
5687: fnd_global.conc_request_id,
5688: NULL,
5689: fnd_global.conc_program_id,
5690: sysdate,
5691: brd.attribute_category,

Line 5689: fnd_global.conc_program_id,

5685: bic.component_sequence_id,
5686: x_acd_type,
5687: fnd_global.conc_request_id,
5688: NULL,
5689: fnd_global.conc_program_id,
5690: sysdate,
5691: brd.attribute_category,
5692: brd.attribute1,
5693: brd.attribute2,

Line 5778: fnd_global.conc_request_id,

5774: MSI.primary_unit_of_measure)) Sub_Comp_qty,
5775: bic.component_sequence_id,
5776: x_acd_type,
5777: x_e_change_notice,
5778: fnd_global.conc_request_id,
5779: NULL,
5780: fnd_global.conc_program_id,
5781: sysdate,
5782: bsc.attribute_category,

Line 5780: fnd_global.conc_program_id,

5776: x_acd_type,
5777: x_e_change_notice,
5778: fnd_global.conc_request_id,
5779: NULL,
5780: fnd_global.conc_program_id,
5781: sysdate,
5782: bsc.attribute_category,
5783: bsc.attribute1,
5784: bsc.attribute2,

Line 5922: fnd_global.conc_request_id,

5918: MSI.primary_unit_of_measure)) Sub_Comp_qty,
5919: bic.component_sequence_id,
5920: x_acd_type,
5921: x_e_change_notice,
5922: fnd_global.conc_request_id,
5923: NULL,
5924: fnd_global.conc_program_id,
5925: sysdate,
5926: bsc.attribute_category,

Line 5924: fnd_global.conc_program_id,

5920: x_acd_type,
5921: x_e_change_notice,
5922: fnd_global.conc_request_id,
5923: NULL,
5924: fnd_global.conc_program_id,
5925: sysdate,
5926: bsc.attribute_category,
5927: bsc.attribute1,
5928: bsc.attribute2,

Line 6051: fnd_global.conc_request_id,

6047: bco.attribute12,
6048: bco.attribute13,
6049: bco.attribute14,
6050: bco.attribute15,
6051: fnd_global.conc_request_id,
6052: NULL,
6053: fnd_global.conc_program_id,
6054: sysdate
6055: FROM bom_component_operations bco,

Line 6053: fnd_global.conc_program_id,

6049: bco.attribute14,
6050: bco.attribute15,
6051: fnd_global.conc_request_id,
6052: NULL,
6053: fnd_global.conc_program_id,
6054: sysdate
6055: FROM bom_component_operations bco,
6056: bom_components_b bic,
6057: bom_operation_sequences bos,

Line 6146: fnd_global.conc_request_id,

6142: bco.attribute12,
6143: bco.attribute13,
6144: bco.attribute14,
6145: bco.attribute15,
6146: fnd_global.conc_request_id,
6147: NULL,
6148: fnd_global.conc_program_id,
6149: sysdate
6150: FROM bom_component_operations bco,

Line 6148: fnd_global.conc_program_id,

6144: bco.attribute14,
6145: bco.attribute15,
6146: fnd_global.conc_request_id,
6147: NULL,
6148: fnd_global.conc_program_id,
6149: sysdate
6150: FROM bom_component_operations bco,
6151: bom_inventory_components bic,
6152: bom_operation_sequences bos

Line 6188: fnd_global.conc_program_id,

6184: SYSDATE,
6185: user_id,
6186: user_id,
6187: NULL,
6188: fnd_global.conc_program_id,
6189: sysdate,
6190: fnd_global.conc_request_id
6191: FROM bom_dependent_desc_elements bdde
6192: WHERE bdde.bill_sequence_id = x_from_sequence_id

Line 6190: fnd_global.conc_request_id

6186: user_id,
6187: NULL,
6188: fnd_global.conc_program_id,
6189: sysdate,
6190: fnd_global.conc_request_id
6191: FROM bom_dependent_desc_elements bdde
6192: WHERE bdde.bill_sequence_id = x_from_sequence_id
6193: AND ((itm_type = model
6194: AND EXISTS (

Line 6227: x_program_id => fnd_global.conc_program_id,

6223: x_to_pk5_value => '',
6224: x_created_by => user_id,
6225: x_last_update_login => '',
6226: x_program_application_id => '',
6227: x_program_id => fnd_global.conc_program_id,
6228: x_request_id => fnd_global.conc_request_id
6229: );
6230: END IF;
6231:

Line 6228: x_request_id => fnd_global.conc_request_id

6224: x_created_by => user_id,
6225: x_last_update_login => '',
6226: x_program_application_id => '',
6227: x_program_id => fnd_global.conc_program_id,
6228: x_request_id => fnd_global.conc_request_id
6229: );
6230: END IF;
6231:
6232: sql_stmt_num := 80;

Line 6313: fnd_global.conc_request_id,

6309: user_id,
6310: SYSDATE,
6311: user_id,
6312: 'E',
6313: fnd_global.conc_request_id,
6314: NULL,
6315: fnd_global.conc_program_id,
6316: sysdate
6317: );

Line 6315: fnd_global.conc_program_id,

6311: user_id,
6312: 'E',
6313: fnd_global.conc_request_id,
6314: NULL,
6315: fnd_global.conc_program_id,
6316: sysdate
6317: );
6318: ELSE
6319: ROLLBACK TO begin_bill_copy;

Line 6362: fnd_global.conc_request_id,

6358: user_id,
6359: SYSDATE,
6360: user_id,
6361: 'E',
6362: fnd_global.conc_request_id,
6363: NULL,
6364: fnd_global.conc_program_id,
6365: sysdate
6366: );

Line 6364: fnd_global.conc_program_id,

6360: user_id,
6361: 'E',
6362: fnd_global.conc_request_id,
6363: NULL,
6364: fnd_global.conc_program_id,
6365: sysdate
6366: );
6367: ELSE
6368: ROLLBACK TO begin_bill_copy;

Line 6731: fnd_global.conc_request_id,

6727: p_usr_id,
6728: SYSDATE,
6729: p_usr_id,
6730: 'E',
6731: fnd_global.conc_request_id,
6732: NULL,
6733: fnd_global.conc_program_id,
6734: sysdate
6735: );

Line 6733: fnd_global.conc_program_id,

6729: p_usr_id,
6730: 'E',
6731: fnd_global.conc_request_id,
6732: NULL,
6733: fnd_global.conc_program_id,
6734: sysdate
6735: );
6736: END IF; -- l_item_org_assign_rec.status <> FND_API.G_RET_STS_SUCCESS
6737: l_index := l_item_org_assign_tbl.NEXT(l_index);

Line 7885: fnd_global.conc_request_id,

7881: NULL, NULL,
7882: bom_inventory_components_s.CURRVAL
7883: ),
7884: to_sequence_id,
7885: fnd_global.conc_request_id,
7886: NULL,
7887: fnd_global.conc_program_id,
7888: sysdate,
7889: bic.wip_supply_type,

Line 7887: fnd_global.conc_program_id,

7883: ),
7884: to_sequence_id,
7885: fnd_global.conc_request_id,
7886: NULL,
7887: fnd_global.conc_program_id,
7888: sysdate,
7889: bic.wip_supply_type,
7890: DECODE (rto_flag, 'Y', 2, bic.pick_components),
7891: DECODE (x_from_org_id,

Line 8254: fnd_global.conc_request_id,

8250: NULL, NULL,
8251: bom_inventory_components_s.CURRVAL
8252: ),
8253: to_sequence_id,
8254: fnd_global.conc_request_id,
8255: NULL,
8256: fnd_global.conc_program_id,
8257: sysdate,
8258: bic.wip_supply_type,

Line 8256: fnd_global.conc_program_id,

8252: ),
8253: to_sequence_id,
8254: fnd_global.conc_request_id,
8255: NULL,
8256: fnd_global.conc_program_id,
8257: sysdate,
8258: bic.wip_supply_type,
8259: DECODE (rto_flag, 'Y', 2, bic.pick_components),
8260: DECODE (x_from_org_id,

Line 8621: fnd_global.conc_request_id,

8617: NULL, NULL,
8618: bom_inventory_components_s.CURRVAL
8619: ),
8620: to_sequence_id,
8621: fnd_global.conc_request_id,
8622: NULL,
8623: fnd_global.conc_program_id,
8624: sysdate,
8625: bic.wip_supply_type,

Line 8623: fnd_global.conc_program_id,

8619: ),
8620: to_sequence_id,
8621: fnd_global.conc_request_id,
8622: NULL,
8623: fnd_global.conc_program_id,
8624: sysdate,
8625: bic.wip_supply_type,
8626: DECODE (rto_flag, 'Y', 2, bic.pick_components),
8627: DECODE (x_from_org_id,

Line 9034: fnd_global.conc_request_id,

9030: NULL, NULL,
9031: bom_inventory_components_s.CURRVAL
9032: ),
9033: to_sequence_id,
9034: fnd_global.conc_request_id,
9035: NULL,
9036: fnd_global.conc_program_id,
9037: sysdate,
9038: bic.wip_supply_type,

Line 9036: fnd_global.conc_program_id,

9032: ),
9033: to_sequence_id,
9034: fnd_global.conc_request_id,
9035: NULL,
9036: fnd_global.conc_program_id,
9037: sysdate,
9038: bic.wip_supply_type,
9039: DECODE (rto_flag, 'Y', 2, bic.pick_components),
9040: DECODE (x_from_org_id,

Line 9434: fnd_global.conc_request_id,

9430: NULL, NULL,
9431: bom_inventory_components_s.CURRVAL
9432: ),
9433: to_sequence_id,
9434: fnd_global.conc_request_id,
9435: NULL,
9436: fnd_global.conc_program_id,
9437: sysdate,
9438: bic.wip_supply_type,

Line 9436: fnd_global.conc_program_id,

9432: ),
9433: to_sequence_id,
9434: fnd_global.conc_request_id,
9435: NULL,
9436: fnd_global.conc_program_id,
9437: sysdate,
9438: bic.wip_supply_type,
9439: DECODE (rto_flag, 'Y', 2, bic.pick_components),
9440: DECODE (x_from_org_id,

Line 9886: fnd_global.conc_request_id,

9882: user_id,
9883: SYSDATE,
9884: user_id,
9885: 'E',
9886: fnd_global.conc_request_id,
9887: NULL,
9888: fnd_global.conc_program_id,
9889: sysdate
9890: FROM bom_components_b bcb,

Line 9888: fnd_global.conc_program_id,

9884: user_id,
9885: 'E',
9886: fnd_global.conc_request_id,
9887: NULL,
9888: fnd_global.conc_program_id,
9889: sysdate
9890: FROM bom_components_b bcb,
9891: mtl_system_items_b_kfv msbk1,
9892: bom_copy_explosions_v bev

Line 10015: fnd_global.conc_request_id,

10011: user_id,
10012: SYSDATE,
10013: user_id,
10014: 'E',
10015: fnd_global.conc_request_id,
10016: NULL,
10017: fnd_global.conc_program_id,
10018: sysdate
10019: FROM bom_components_b bcb,

Line 10017: fnd_global.conc_program_id,

10013: user_id,
10014: 'E',
10015: fnd_global.conc_request_id,
10016: NULL,
10017: fnd_global.conc_program_id,
10018: sysdate
10019: FROM bom_components_b bcb,
10020: mtl_system_items_b_kfv msbk1,
10021: bom_copy_explosions_v bev

Line 10080: fnd_global.conc_request_id,

10076: user_id,
10077: SYSDATE,
10078: user_id,
10079: 'E',
10080: fnd_global.conc_request_id,
10081: NULL,
10082: fnd_global.conc_program_id,
10083: sysdate
10084: FROM bom_components_b bcb,

Line 10082: fnd_global.conc_program_id,

10078: user_id,
10079: 'E',
10080: fnd_global.conc_request_id,
10081: NULL,
10082: fnd_global.conc_program_id,
10083: sysdate
10084: FROM bom_components_b bcb,
10085: mtl_system_items_b msib1, -- component
10086: bom_copy_explosions_v bev

Line 10182: fnd_global.conc_request_id,

10178: user_id,
10179: SYSDATE,
10180: user_id,
10181: 'E',
10182: fnd_global.conc_request_id,
10183: NULL,
10184: fnd_global.conc_program_id,
10185: sysdate
10186: FROM bom_components_b bcb,

Line 10184: fnd_global.conc_program_id,

10180: user_id,
10181: 'E',
10182: fnd_global.conc_request_id,
10183: NULL,
10184: fnd_global.conc_program_id,
10185: sysdate
10186: FROM bom_components_b bcb,
10187: bom_copy_explosions_v bev
10188: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 10281: fnd_global.conc_request_id,

10277: user_id,
10278: SYSDATE,
10279: user_id,
10280: 'E',
10281: fnd_global.conc_request_id,
10282: NULL,
10283: fnd_global.conc_program_id,
10284: sysdate
10285: FROM bom_components_b bcb,

Line 10283: fnd_global.conc_program_id,

10279: user_id,
10280: 'E',
10281: fnd_global.conc_request_id,
10282: NULL,
10283: fnd_global.conc_program_id,
10284: sysdate
10285: FROM bom_components_b bcb,
10286: mtl_system_items_b msib1,
10287: bom_copy_explosions_v bev

Line 10381: fnd_global.conc_request_id,

10377: user_id,
10378: SYSDATE,
10379: user_id,
10380: 'E',
10381: fnd_global.conc_request_id,
10382: NULL,
10383: fnd_global.conc_program_id,
10384: sysdate
10385: FROM bom_components_b bcb,

Line 10383: fnd_global.conc_program_id,

10379: user_id,
10380: 'E',
10381: fnd_global.conc_request_id,
10382: NULL,
10383: fnd_global.conc_program_id,
10384: sysdate
10385: FROM bom_components_b bcb,
10386: bom_copy_explosions_v bev
10387: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 10484: fnd_global.conc_request_id,

10480: user_id,
10481: SYSDATE,
10482: user_id,
10483: 'E',
10484: fnd_global.conc_request_id,
10485: NULL,
10486: fnd_global.conc_program_id,
10487: sysdate
10488: FROM bom_components_b bcb,

Line 10486: fnd_global.conc_program_id,

10482: user_id,
10483: 'E',
10484: fnd_global.conc_request_id,
10485: NULL,
10486: fnd_global.conc_program_id,
10487: sysdate
10488: FROM bom_components_b bcb,
10489: mtl_system_items_b msib
10490: WHERE bcb.bill_sequence_id = to_sequence_id

Line 10549: fnd_global.conc_request_id,

10545: user_id,
10546: SYSDATE,
10547: user_id,
10548: 'E',
10549: fnd_global.conc_request_id,
10550: NULL,
10551: fnd_global.conc_program_id,
10552: sysdate
10553: FROM bom_components_b bcb,

Line 10551: fnd_global.conc_program_id,

10547: user_id,
10548: 'E',
10549: fnd_global.conc_request_id,
10550: NULL,
10551: fnd_global.conc_program_id,
10552: sysdate
10553: FROM bom_components_b bcb,
10554: mtl_system_items_b msib
10555: WHERE bcb.bill_sequence_id = to_sequence_id

Line 10624: fnd_global.conc_request_id,

10620: user_id,
10621: SYSDATE,
10622: user_id,
10623: 'E',
10624: fnd_global.conc_request_id,
10625: NULL,
10626: fnd_global.conc_program_id,
10627: sysdate
10628: FROM bom_components_b bcb,

Line 10626: fnd_global.conc_program_id,

10622: user_id,
10623: 'E',
10624: fnd_global.conc_request_id,
10625: NULL,
10626: fnd_global.conc_program_id,
10627: sysdate
10628: FROM bom_components_b bcb,
10629: bom_copy_explosions_v bev
10630: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 10955: fnd_global.conc_request_id,

10951: user_id,
10952: SYSDATE,
10953: user_id,
10954: 'E',
10955: fnd_global.conc_request_id,
10956: NULL,
10957: fnd_global.conc_program_id,
10958: sysdate
10959: FROM bom_components_b bcb,

Line 10957: fnd_global.conc_program_id,

10953: user_id,
10954: 'E',
10955: fnd_global.conc_request_id,
10956: NULL,
10957: fnd_global.conc_program_id,
10958: sysdate
10959: FROM bom_components_b bcb,
10960: mtl_system_items_b msib1,
10961: mtl_system_items_b msib2

Line 11009: fnd_global.conc_request_id,

11005: user_id,
11006: SYSDATE,
11007: user_id,
11008: 'E',
11009: fnd_global.conc_request_id,
11010: NULL,
11011: fnd_global.conc_program_id,
11012: sysdate
11013: FROM bom_components_b bcb,

Line 11011: fnd_global.conc_program_id,

11007: user_id,
11008: 'E',
11009: fnd_global.conc_request_id,
11010: NULL,
11011: fnd_global.conc_program_id,
11012: sysdate
11013: FROM bom_components_b bcb,
11014: mtl_system_items_b msib1,
11015: mtl_system_items_b msib2

Line 11064: fnd_global.conc_request_id,

11060: user_id,
11061: SYSDATE,
11062: user_id,
11063: 'E',
11064: fnd_global.conc_request_id,
11065: NULL,
11066: fnd_global.conc_program_id,
11067: sysdate
11068: FROM bom_components_b bcb,

Line 11066: fnd_global.conc_program_id,

11062: user_id,
11063: 'E',
11064: fnd_global.conc_request_id,
11065: NULL,
11066: fnd_global.conc_program_id,
11067: sysdate
11068: FROM bom_components_b bcb,
11069: mtl_system_items_b msib1, -- Comp
11070: mtl_system_items_b msib2 -- Structure

Line 11119: fnd_global.conc_request_id,

11115: user_id,
11116: SYSDATE,
11117: user_id,
11118: 'E',
11119: fnd_global.conc_request_id,
11120: NULL,
11121: fnd_global.conc_program_id,
11122: sysdate
11123: FROM bom_components_b bcb,

Line 11121: fnd_global.conc_program_id,

11117: user_id,
11118: 'E',
11119: fnd_global.conc_request_id,
11120: NULL,
11121: fnd_global.conc_program_id,
11122: sysdate
11123: FROM bom_components_b bcb,
11124: mtl_system_items_b msib1, -- Comp
11125: mtl_system_items_b msib2 -- Structure

Line 11175: fnd_global.conc_request_id,

11171: user_id,
11172: SYSDATE,
11173: user_id,
11174: 'E',
11175: fnd_global.conc_request_id,
11176: NULL,
11177: fnd_global.conc_program_id,
11178: sysdate
11179: FROM bom_components_b bcb,

Line 11177: fnd_global.conc_program_id,

11173: user_id,
11174: 'E',
11175: fnd_global.conc_request_id,
11176: NULL,
11177: fnd_global.conc_program_id,
11178: sysdate
11179: FROM bom_components_b bcb,
11180: mtl_system_items_b msib1, -- Comp
11181: mtl_system_items_b msib2 -- Structure

Line 11313: fnd_global.conc_request_id,

11309: ref_designator_comment,
11310: x_e_change_notice,
11311: bic.component_sequence_id,
11312: x_acd_type,
11313: fnd_global.conc_request_id,
11314: NULL,
11315: fnd_global.conc_program_id,
11316: sysdate,
11317: brd.attribute_category,

Line 11315: fnd_global.conc_program_id,

11311: bic.component_sequence_id,
11312: x_acd_type,
11313: fnd_global.conc_request_id,
11314: NULL,
11315: fnd_global.conc_program_id,
11316: sysdate,
11317: brd.attribute_category,
11318: brd.attribute1,
11319: brd.attribute2,

Line 11402: fnd_global.conc_request_id,

11398: MSI.primary_unit_of_measure)) Sub_Comp_qty,
11399: bic.component_sequence_id,
11400: x_acd_type,
11401: x_e_change_notice,
11402: fnd_global.conc_request_id,
11403: NULL,
11404: fnd_global.conc_program_id,
11405: sysdate,
11406: bsc.attribute_category,

Line 11404: fnd_global.conc_program_id,

11400: x_acd_type,
11401: x_e_change_notice,
11402: fnd_global.conc_request_id,
11403: NULL,
11404: fnd_global.conc_program_id,
11405: sysdate,
11406: bsc.attribute_category,
11407: bsc.attribute1,
11408: bsc.attribute2,

Line 11569: fnd_global.conc_request_id,

11565: bco.attribute12,
11566: bco.attribute13,
11567: bco.attribute14,
11568: bco.attribute15,
11569: fnd_global.conc_request_id,
11570: NULL,
11571: fnd_global.conc_program_id,
11572: sysdate
11573: FROM bom_component_operations bco,

Line 11571: fnd_global.conc_program_id,

11567: bco.attribute14,
11568: bco.attribute15,
11569: fnd_global.conc_request_id,
11570: NULL,
11571: fnd_global.conc_program_id,
11572: sysdate
11573: FROM bom_component_operations bco,
11574: bom_components_b bic,
11575: bom_operation_sequences bos,

Line 11615: fnd_global.conc_program_id,

11611: SYSDATE,
11612: user_id,
11613: user_id,
11614: NULL,
11615: fnd_global.conc_program_id,
11616: sysdate,
11617: fnd_global.conc_request_id
11618: FROM bom_dependent_desc_elements bdde
11619: WHERE bdde.bill_sequence_id = x_from_sequence_id

Line 11617: fnd_global.conc_request_id

11613: user_id,
11614: NULL,
11615: fnd_global.conc_program_id,
11616: sysdate,
11617: fnd_global.conc_request_id
11618: FROM bom_dependent_desc_elements bdde
11619: WHERE bdde.bill_sequence_id = x_from_sequence_id
11620: AND ((itm_type = model
11621: AND EXISTS (

Line 11674: fnd_global.conc_request_id,

11670: user_id,
11671: SYSDATE,
11672: user_id,
11673: 'E',
11674: fnd_global.conc_request_id,
11675: NULL,
11676: fnd_global.conc_program_id,
11677: sysdate
11678: );

Line 11676: fnd_global.conc_program_id,

11672: user_id,
11673: 'E',
11674: fnd_global.conc_request_id,
11675: NULL,
11676: fnd_global.conc_program_id,
11677: sysdate
11678: );
11679: WHEN common_error
11680: THEN

Line 11717: fnd_global.conc_request_id,

11713: user_id,
11714: SYSDATE,
11715: user_id,
11716: 'E',
11717: fnd_global.conc_request_id,
11718: NULL,
11719: fnd_global.conc_program_id,
11720: sysdate
11721: );

Line 11719: fnd_global.conc_program_id,

11715: user_id,
11716: 'E',
11717: fnd_global.conc_request_id,
11718: NULL,
11719: fnd_global.conc_program_id,
11720: sysdate
11721: );
11722: WHEN OTHERS
11723: THEN

Line 11753: x_program_id => fnd_global.conc_program_id,

11749: x_to_pk5_value => '',
11750: x_created_by => p_user_id,
11751: x_last_update_login => '',
11752: x_program_application_id => '',
11753: x_program_id => fnd_global.conc_program_id,
11754: x_request_id => fnd_global.conc_request_id
11755: );
11756: END;
11757:

Line 11754: x_request_id => fnd_global.conc_request_id

11750: x_created_by => p_user_id,
11751: x_last_update_login => '',
11752: x_program_application_id => '',
11753: x_program_id => fnd_global.conc_program_id,
11754: x_request_id => fnd_global.conc_request_id
11755: );
11756: END;
11757:
11758: FUNCTION get_comp_type_rule_message(p_msg_name IN VARCHAR2,

Line 11823: l_conc_request_id number := FND_GLOBAL.CONC_REQUEST_ID;

11819: l_return_status VARCHAR2(1):= 'Y';
11820: l_msg_count number;
11821: l_item_org_assignment_tbl EGO_Item_PUB.Item_Org_Assignment_Tbl_Type;
11822:
11823: l_conc_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
11824:
11825: CURSOR l_un_assign_eco_comps ( p_bill_seq_id NUMBER
11826: , p_org_id NUMBER)
11827: IS

Line 11895: fnd_global.initialize(FND_CONST.CONC_REQUEST_ID, -1);

11891:
11892: BEGIN
11893: IF p_api_version = 1 then
11894: -- set request id -1 to avoid raising EGO_WF_WRAPPER_PVT.G_ITEM_BULKLOAD_EVENT event
11895: fnd_global.initialize(FND_CONST.CONC_REQUEST_ID, -1);
11896:
11897: FOR comps_rec IN l_un_assign_eco_comps(p_bill_sequence_id, p_organization_id) LOOP
11898: IF ( comps_rec.change_notice is not null AND comps_rec.implementation_date is null) THEN
11899: l_item_org_assignment_tbl(1).Inventory_Item_Id := comps_rec.component_item_id;

Line 11911: fnd_global.initialize(FND_CONST.CONC_REQUEST_ID, l_conc_request_id);

11907: , x_return_status => l_return_status);
11908: END IF;
11909: END LOOP;
11910:
11911: fnd_global.initialize(FND_CONST.CONC_REQUEST_ID, l_conc_request_id);
11912:
11913: END IF; -- p_api_version = 1.0
11914:
11915: x_return_status := l_return_status;