DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on FND_GLOBAL

Line 1381: fnd_global.conc_request_id,

1377: user_id,
1378: SYSDATE,
1379: user_id,
1380: 'E',
1381: fnd_global.conc_request_id,
1382: NULL,
1383: fnd_global.conc_program_id,
1384: sysdate
1385: FROM dual;

Line 1383: fnd_global.conc_program_id,

1379: user_id,
1380: 'E',
1381: fnd_global.conc_request_id,
1382: NULL,
1383: fnd_global.conc_program_id,
1384: sysdate
1385: FROM dual;
1386: l_msg_count := l_error_msg_tbl.next(l_msg_count);
1387: END LOOP;

Line 1520: fnd_global.conc_request_id,

1516: NULL, NULL,
1517: bom_inventory_components_s.CURRVAL
1518: ),
1519: to_sequence_id,
1520: fnd_global.conc_request_id,
1521: NULL,
1522: fnd_global.conc_program_id,
1523: sysdate,
1524: bic.wip_supply_type,

Line 1522: fnd_global.conc_program_id,

1518: ),
1519: to_sequence_id,
1520: fnd_global.conc_request_id,
1521: NULL,
1522: fnd_global.conc_program_id,
1523: sysdate,
1524: bic.wip_supply_type,
1525: DECODE (rto_flag, 'Y', 2, bic.pick_components),
1526: DECODE (x_from_org_id,

Line 1916: fnd_global.conc_request_id,

1912: NULL, NULL,
1913: bom_inventory_components_s.CURRVAL
1914: ),
1915: to_sequence_id,
1916: fnd_global.conc_request_id,
1917: NULL,
1918: fnd_global.conc_program_id,
1919: sysdate,
1920: bic.wip_supply_type,

Line 1918: fnd_global.conc_program_id,

1914: ),
1915: to_sequence_id,
1916: fnd_global.conc_request_id,
1917: NULL,
1918: fnd_global.conc_program_id,
1919: sysdate,
1920: bic.wip_supply_type,
1921: DECODE (rto_flag, 'Y', 2, bic.pick_components),
1922: DECODE (x_from_org_id,

Line 2317: fnd_global.conc_request_id,

2313: NULL, NULL,
2314: bom_inventory_components_s.CURRVAL
2315: ),
2316: to_sequence_id,
2317: fnd_global.conc_request_id,
2318: NULL,
2319: fnd_global.conc_program_id,
2320: sysdate,
2321: bic.wip_supply_type,

Line 2319: fnd_global.conc_program_id,

2315: ),
2316: to_sequence_id,
2317: fnd_global.conc_request_id,
2318: NULL,
2319: fnd_global.conc_program_id,
2320: sysdate,
2321: bic.wip_supply_type,
2322: DECODE (rto_flag, 'Y', 2, bic.pick_components),
2323: DECODE (x_from_org_id,

Line 2792: fnd_global.conc_request_id,

2788: NULL, NULL,
2789: bom_inventory_components_s.CURRVAL
2790: ),
2791: to_sequence_id,
2792: fnd_global.conc_request_id,
2793: NULL,
2794: fnd_global.conc_program_id,
2795: sysdate,
2796: bic.wip_supply_type,

Line 2794: fnd_global.conc_program_id,

2790: ),
2791: to_sequence_id,
2792: fnd_global.conc_request_id,
2793: NULL,
2794: fnd_global.conc_program_id,
2795: sysdate,
2796: bic.wip_supply_type,
2797: DECODE (rto_flag, 'Y', 2, bic.pick_components),
2798: DECODE (x_from_org_id,

Line 3234: fnd_global.conc_request_id,

3230: NULL, NULL,
3231: bom_inventory_components_s.CURRVAL
3232: ),
3233: to_sequence_id,
3234: fnd_global.conc_request_id,
3235: NULL,
3236: fnd_global.conc_program_id,
3237: sysdate,
3238: bic.wip_supply_type,

Line 3236: fnd_global.conc_program_id,

3232: ),
3233: to_sequence_id,
3234: fnd_global.conc_request_id,
3235: NULL,
3236: fnd_global.conc_program_id,
3237: sysdate,
3238: bic.wip_supply_type,
3239: DECODE (rto_flag, 'Y', 2, bic.pick_components),
3240: DECODE (x_from_org_id,

Line 3716: fnd_global.conc_request_id,

3712: user_id,
3713: SYSDATE,
3714: user_id,
3715: 'E',
3716: fnd_global.conc_request_id,
3717: NULL,
3718: fnd_global.conc_program_id,
3719: sysdate
3720: FROM bom_components_b bcb

Line 3718: fnd_global.conc_program_id,

3714: user_id,
3715: 'E',
3716: fnd_global.conc_request_id,
3717: NULL,
3718: fnd_global.conc_program_id,
3719: sysdate
3720: FROM bom_components_b bcb
3721: WHERE bcb.component_sequence_id = l_from_comps(l_index);
3722: l_msg_count := l_error_msg_tbl.next(l_msg_count);

Line 3838: fnd_global.conc_request_id,

3834: user_id,
3835: SYSDATE,
3836: user_id,
3837: 'E',
3838: fnd_global.conc_request_id,
3839: NULL,
3840: fnd_global.conc_program_id,
3841: sysdate
3842: FROM mtl_system_items_b_kfv msbk1

Line 3840: fnd_global.conc_program_id,

3836: user_id,
3837: 'E',
3838: fnd_global.conc_request_id,
3839: NULL,
3840: fnd_global.conc_program_id,
3841: sysdate
3842: FROM mtl_system_items_b_kfv msbk1
3843: WHERE msbk1.inventory_item_id = from_item_id
3844: AND msbk1.organization_id = from_org_id;

Line 3935: fnd_global.conc_request_id,

3931: user_id,
3932: SYSDATE,
3933: user_id,
3934: 'E',
3935: fnd_global.conc_request_id,
3936: NULL,
3937: fnd_global.conc_program_id,
3938: sysdate
3939: FROM mtl_system_items_b_kfv msbk1

Line 3937: fnd_global.conc_program_id,

3933: user_id,
3934: 'E',
3935: fnd_global.conc_request_id,
3936: NULL,
3937: fnd_global.conc_program_id,
3938: sysdate
3939: FROM mtl_system_items_b_kfv msbk1
3940: WHERE msbk1.inventory_item_id = from_item_id
3941: AND msbk1.organization_id = from_org_id;

Line 3982: fnd_global.conc_request_id,

3978: user_id,
3979: SYSDATE,
3980: user_id,
3981: 'E',
3982: fnd_global.conc_request_id,
3983: NULL,
3984: fnd_global.conc_program_id,
3985: sysdate
3986: FROM bom_components_b bcb,

Line 3984: fnd_global.conc_program_id,

3980: user_id,
3981: 'E',
3982: fnd_global.conc_request_id,
3983: NULL,
3984: fnd_global.conc_program_id,
3985: sysdate
3986: FROM bom_components_b bcb,
3987: mtl_system_items_b msib, -- component
3988: bom_copy_explosions_v bev

Line 4071: fnd_global.conc_request_id,

4067: user_id,
4068: SYSDATE,
4069: user_id,
4070: 'E',
4071: fnd_global.conc_request_id,
4072: NULL,
4073: fnd_global.conc_program_id,
4074: sysdate
4075: FROM bom_components_b bcb,

Line 4073: fnd_global.conc_program_id,

4069: user_id,
4070: 'E',
4071: fnd_global.conc_request_id,
4072: NULL,
4073: fnd_global.conc_program_id,
4074: sysdate
4075: FROM bom_components_b bcb,
4076: bom_copy_explosions_v bev
4077: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 4210: fnd_global.conc_request_id,

4206: user_id,
4207: SYSDATE,
4208: user_id,
4209: 'E',
4210: fnd_global.conc_request_id,
4211: NULL,
4212: fnd_global.conc_program_id,
4213: sysdate
4214: FROM bom_components_b bcb,

Line 4212: fnd_global.conc_program_id,

4208: user_id,
4209: 'E',
4210: fnd_global.conc_request_id,
4211: NULL,
4212: fnd_global.conc_program_id,
4213: sysdate
4214: FROM bom_components_b bcb,
4215: mtl_system_items_b msib,
4216: bom_copy_explosions_v bev

Line 4297: fnd_global.conc_request_id,

4293: user_id,
4294: SYSDATE,
4295: user_id,
4296: 'E',
4297: fnd_global.conc_request_id,
4298: NULL,
4299: fnd_global.conc_program_id,
4300: sysdate
4301: FROM bom_components_b bcb,

Line 4299: fnd_global.conc_program_id,

4295: user_id,
4296: 'E',
4297: fnd_global.conc_request_id,
4298: NULL,
4299: fnd_global.conc_program_id,
4300: sysdate
4301: FROM bom_components_b bcb,
4302: bom_copy_explosions_v bev
4303: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 4393: fnd_global.conc_request_id,

4389: user_id,
4390: SYSDATE,
4391: user_id,
4392: 'E',
4393: fnd_global.conc_request_id,
4394: NULL,
4395: fnd_global.conc_program_id,
4396: sysdate
4397: FROM bom_components_b bcb,

Line 4395: fnd_global.conc_program_id,

4391: user_id,
4392: 'E',
4393: fnd_global.conc_request_id,
4394: NULL,
4395: fnd_global.conc_program_id,
4396: sysdate
4397: FROM bom_components_b bcb,
4398: mtl_system_items_b msib
4399: WHERE bcb.bill_sequence_id = to_sequence_id

Line 4458: fnd_global.conc_request_id,

4454: user_id,
4455: SYSDATE,
4456: user_id,
4457: 'E',
4458: fnd_global.conc_request_id,
4459: NULL,
4460: fnd_global.conc_program_id,
4461: sysdate
4462: FROM bom_components_b bcb,

Line 4460: fnd_global.conc_program_id,

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

Line 4532: fnd_global.conc_request_id,

4528: user_id,
4529: SYSDATE,
4530: user_id,
4531: 'E',
4532: fnd_global.conc_request_id,
4533: NULL,
4534: fnd_global.conc_program_id,
4535: sysdate
4536: FROM bom_components_b bcb,

Line 4534: fnd_global.conc_program_id,

4530: user_id,
4531: 'E',
4532: fnd_global.conc_request_id,
4533: NULL,
4534: fnd_global.conc_program_id,
4535: sysdate
4536: FROM bom_components_b bcb,
4537: bom_copy_explosions_v bev
4538: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 4715: fnd_global.conc_request_id,

4711: NULL, NULL,
4712: bom_inventory_components_s.CURRVAL
4713: ),
4714: to_sequence_id,
4715: fnd_global.conc_request_id,
4716: NULL,
4717: fnd_global.conc_program_id,
4718: sysdate,
4719: bic.wip_supply_type,

Line 4717: fnd_global.conc_program_id,

4713: ),
4714: to_sequence_id,
4715: fnd_global.conc_request_id,
4716: NULL,
4717: fnd_global.conc_program_id,
4718: sysdate,
4719: bic.wip_supply_type,
4720: DECODE (rto_flag, 'Y', 2, pick_components),
4721: DECODE (x_from_org_id,

Line 5166: fnd_global.conc_request_id,

5162: user_id,
5163: SYSDATE,
5164: user_id,
5165: 'E',
5166: fnd_global.conc_request_id,
5167: NULL,
5168: fnd_global.conc_program_id,
5169: sysdate
5170: FROM bom_components_b bcb,

Line 5168: fnd_global.conc_program_id,

5164: user_id,
5165: 'E',
5166: fnd_global.conc_request_id,
5167: NULL,
5168: fnd_global.conc_program_id,
5169: sysdate
5170: FROM bom_components_b bcb,
5171: mtl_system_items_b msib1,
5172: mtl_system_items_b msib2

Line 5219: fnd_global.conc_request_id,

5215: user_id,
5216: SYSDATE,
5217: user_id,
5218: 'E',
5219: fnd_global.conc_request_id,
5220: NULL,
5221: fnd_global.conc_program_id,
5222: sysdate
5223: FROM bom_components_b bcb,

Line 5221: fnd_global.conc_program_id,

5217: user_id,
5218: 'E',
5219: fnd_global.conc_request_id,
5220: NULL,
5221: fnd_global.conc_program_id,
5222: sysdate
5223: FROM bom_components_b bcb,
5224: mtl_system_items_b msib1,
5225: mtl_system_items_b msib2

Line 5273: fnd_global.conc_request_id,

5269: user_id,
5270: SYSDATE,
5271: user_id,
5272: 'E',
5273: fnd_global.conc_request_id,
5274: NULL,
5275: fnd_global.conc_program_id,
5276: sysdate
5277: FROM bom_components_b bcb,

Line 5275: fnd_global.conc_program_id,

5271: user_id,
5272: 'E',
5273: fnd_global.conc_request_id,
5274: NULL,
5275: fnd_global.conc_program_id,
5276: sysdate
5277: FROM bom_components_b bcb,
5278: mtl_system_items_b msib1, -- Comp
5279: mtl_system_items_b msib2 -- Structure

Line 5327: fnd_global.conc_request_id,

5323: user_id,
5324: SYSDATE,
5325: user_id,
5326: 'E',
5327: fnd_global.conc_request_id,
5328: NULL,
5329: fnd_global.conc_program_id,
5330: sysdate
5331: FROM bom_components_b bcb,

Line 5329: fnd_global.conc_program_id,

5325: user_id,
5326: 'E',
5327: fnd_global.conc_request_id,
5328: NULL,
5329: fnd_global.conc_program_id,
5330: sysdate
5331: FROM bom_components_b bcb,
5332: mtl_system_items_b msib1, -- Comp
5333: mtl_system_items_b msib2 -- Structure

Line 5382: fnd_global.conc_request_id,

5378: user_id,
5379: SYSDATE,
5380: user_id,
5381: 'E',
5382: fnd_global.conc_request_id,
5383: NULL,
5384: fnd_global.conc_program_id,
5385: sysdate
5386: FROM bom_components_b bcb,

Line 5384: fnd_global.conc_program_id,

5380: user_id,
5381: 'E',
5382: fnd_global.conc_request_id,
5383: NULL,
5384: fnd_global.conc_program_id,
5385: sysdate
5386: FROM bom_components_b bcb,
5387: mtl_system_items_b msib1, -- Comp
5388: mtl_system_items_b msib2 -- Structure

Line 5519: fnd_global.conc_request_id,

5515: ref_designator_comment,
5516: x_e_change_notice,
5517: bic.component_sequence_id,
5518: x_acd_type,
5519: fnd_global.conc_request_id,
5520: NULL,
5521: fnd_global.conc_program_id,
5522: sysdate,
5523: brd.attribute_category,

Line 5521: fnd_global.conc_program_id,

5517: bic.component_sequence_id,
5518: x_acd_type,
5519: fnd_global.conc_request_id,
5520: NULL,
5521: fnd_global.conc_program_id,
5522: sysdate,
5523: brd.attribute_category,
5524: brd.attribute1,
5525: brd.attribute2,

Line 5596: fnd_global.conc_request_id,

5592: ref_designator_comment,
5593: x_e_change_notice,
5594: bic.component_sequence_id,
5595: x_acd_type,
5596: fnd_global.conc_request_id,
5597: NULL,
5598: fnd_global.conc_program_id,
5599: sysdate,
5600: brd.attribute_category,

Line 5598: fnd_global.conc_program_id,

5594: bic.component_sequence_id,
5595: x_acd_type,
5596: fnd_global.conc_request_id,
5597: NULL,
5598: fnd_global.conc_program_id,
5599: sysdate,
5600: brd.attribute_category,
5601: brd.attribute1,
5602: brd.attribute2,

Line 5687: fnd_global.conc_request_id,

5683: MSI.primary_unit_of_measure)) Sub_Comp_qty,
5684: bic.component_sequence_id,
5685: x_acd_type,
5686: x_e_change_notice,
5687: fnd_global.conc_request_id,
5688: NULL,
5689: fnd_global.conc_program_id,
5690: sysdate,
5691: bsc.attribute_category,

Line 5689: fnd_global.conc_program_id,

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

Line 5830: fnd_global.conc_request_id,

5826: MSI.primary_unit_of_measure)) Sub_Comp_qty,
5827: bic.component_sequence_id,
5828: x_acd_type,
5829: x_e_change_notice,
5830: fnd_global.conc_request_id,
5831: NULL,
5832: fnd_global.conc_program_id,
5833: sysdate,
5834: bsc.attribute_category,

Line 5832: fnd_global.conc_program_id,

5828: x_acd_type,
5829: x_e_change_notice,
5830: fnd_global.conc_request_id,
5831: NULL,
5832: fnd_global.conc_program_id,
5833: sysdate,
5834: bsc.attribute_category,
5835: bsc.attribute1,
5836: bsc.attribute2,

Line 5955: fnd_global.conc_request_id,

5951: bco.attribute12,
5952: bco.attribute13,
5953: bco.attribute14,
5954: bco.attribute15,
5955: fnd_global.conc_request_id,
5956: NULL,
5957: fnd_global.conc_program_id,
5958: sysdate
5959: FROM bom_component_operations bco,

Line 5957: fnd_global.conc_program_id,

5953: bco.attribute14,
5954: bco.attribute15,
5955: fnd_global.conc_request_id,
5956: NULL,
5957: fnd_global.conc_program_id,
5958: sysdate
5959: FROM bom_component_operations bco,
5960: bom_components_b bic,
5961: bom_operation_sequences bos,

Line 6050: fnd_global.conc_request_id,

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

Line 6052: fnd_global.conc_program_id,

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

Line 6092: fnd_global.conc_program_id,

6088: SYSDATE,
6089: user_id,
6090: user_id,
6091: NULL,
6092: fnd_global.conc_program_id,
6093: sysdate,
6094: fnd_global.conc_request_id
6095: FROM bom_dependent_desc_elements bdde
6096: WHERE bdde.bill_sequence_id = x_from_sequence_id

Line 6094: fnd_global.conc_request_id

6090: user_id,
6091: NULL,
6092: fnd_global.conc_program_id,
6093: sysdate,
6094: fnd_global.conc_request_id
6095: FROM bom_dependent_desc_elements bdde
6096: WHERE bdde.bill_sequence_id = x_from_sequence_id
6097: AND ((itm_type = model
6098: AND EXISTS (

Line 6131: x_program_id => fnd_global.conc_program_id,

6127: x_to_pk5_value => '',
6128: x_created_by => user_id,
6129: x_last_update_login => '',
6130: x_program_application_id => '',
6131: x_program_id => fnd_global.conc_program_id,
6132: x_request_id => fnd_global.conc_request_id
6133: );
6134: END IF;
6135:

Line 6132: x_request_id => fnd_global.conc_request_id

6128: x_created_by => user_id,
6129: x_last_update_login => '',
6130: x_program_application_id => '',
6131: x_program_id => fnd_global.conc_program_id,
6132: x_request_id => fnd_global.conc_request_id
6133: );
6134: END IF;
6135:
6136: sql_stmt_num := 80;

Line 6217: fnd_global.conc_request_id,

6213: user_id,
6214: SYSDATE,
6215: user_id,
6216: 'E',
6217: fnd_global.conc_request_id,
6218: NULL,
6219: fnd_global.conc_program_id,
6220: sysdate
6221: );

Line 6219: fnd_global.conc_program_id,

6215: user_id,
6216: 'E',
6217: fnd_global.conc_request_id,
6218: NULL,
6219: fnd_global.conc_program_id,
6220: sysdate
6221: );
6222: ELSE
6223: ROLLBACK TO begin_bill_copy;

Line 6266: fnd_global.conc_request_id,

6262: user_id,
6263: SYSDATE,
6264: user_id,
6265: 'E',
6266: fnd_global.conc_request_id,
6267: NULL,
6268: fnd_global.conc_program_id,
6269: sysdate
6270: );

Line 6268: fnd_global.conc_program_id,

6264: user_id,
6265: 'E',
6266: fnd_global.conc_request_id,
6267: NULL,
6268: fnd_global.conc_program_id,
6269: sysdate
6270: );
6271: ELSE
6272: ROLLBACK TO begin_bill_copy;

Line 6635: fnd_global.conc_request_id,

6631: p_usr_id,
6632: SYSDATE,
6633: p_usr_id,
6634: 'E',
6635: fnd_global.conc_request_id,
6636: NULL,
6637: fnd_global.conc_program_id,
6638: sysdate
6639: );

Line 6637: fnd_global.conc_program_id,

6633: p_usr_id,
6634: 'E',
6635: fnd_global.conc_request_id,
6636: NULL,
6637: fnd_global.conc_program_id,
6638: sysdate
6639: );
6640: END IF; -- l_item_org_assign_rec.status <> FND_API.G_RET_STS_SUCCESS
6641: l_index := l_item_org_assign_tbl.NEXT(l_index);

Line 7744: fnd_global.conc_request_id,

7740: NULL, NULL,
7741: bom_inventory_components_s.CURRVAL
7742: ),
7743: to_sequence_id,
7744: fnd_global.conc_request_id,
7745: NULL,
7746: fnd_global.conc_program_id,
7747: sysdate,
7748: bic.wip_supply_type,

Line 7746: fnd_global.conc_program_id,

7742: ),
7743: to_sequence_id,
7744: fnd_global.conc_request_id,
7745: NULL,
7746: fnd_global.conc_program_id,
7747: sysdate,
7748: bic.wip_supply_type,
7749: DECODE (rto_flag, 'Y', 2, bic.pick_components),
7750: DECODE (x_from_org_id,

Line 8113: fnd_global.conc_request_id,

8109: NULL, NULL,
8110: bom_inventory_components_s.CURRVAL
8111: ),
8112: to_sequence_id,
8113: fnd_global.conc_request_id,
8114: NULL,
8115: fnd_global.conc_program_id,
8116: sysdate,
8117: bic.wip_supply_type,

Line 8115: fnd_global.conc_program_id,

8111: ),
8112: to_sequence_id,
8113: fnd_global.conc_request_id,
8114: NULL,
8115: fnd_global.conc_program_id,
8116: sysdate,
8117: bic.wip_supply_type,
8118: DECODE (rto_flag, 'Y', 2, bic.pick_components),
8119: DECODE (x_from_org_id,

Line 8479: fnd_global.conc_request_id,

8475: NULL, NULL,
8476: bom_inventory_components_s.CURRVAL
8477: ),
8478: to_sequence_id,
8479: fnd_global.conc_request_id,
8480: NULL,
8481: fnd_global.conc_program_id,
8482: sysdate,
8483: bic.wip_supply_type,

Line 8481: fnd_global.conc_program_id,

8477: ),
8478: to_sequence_id,
8479: fnd_global.conc_request_id,
8480: NULL,
8481: fnd_global.conc_program_id,
8482: sysdate,
8483: bic.wip_supply_type,
8484: DECODE (rto_flag, 'Y', 2, bic.pick_components),
8485: DECODE (x_from_org_id,

Line 8891: fnd_global.conc_request_id,

8887: NULL, NULL,
8888: bom_inventory_components_s.CURRVAL
8889: ),
8890: to_sequence_id,
8891: fnd_global.conc_request_id,
8892: NULL,
8893: fnd_global.conc_program_id,
8894: sysdate,
8895: bic.wip_supply_type,

Line 8893: fnd_global.conc_program_id,

8889: ),
8890: to_sequence_id,
8891: fnd_global.conc_request_id,
8892: NULL,
8893: fnd_global.conc_program_id,
8894: sysdate,
8895: bic.wip_supply_type,
8896: DECODE (rto_flag, 'Y', 2, bic.pick_components),
8897: DECODE (x_from_org_id,

Line 9290: fnd_global.conc_request_id,

9286: NULL, NULL,
9287: bom_inventory_components_s.CURRVAL
9288: ),
9289: to_sequence_id,
9290: fnd_global.conc_request_id,
9291: NULL,
9292: fnd_global.conc_program_id,
9293: sysdate,
9294: bic.wip_supply_type,

Line 9292: fnd_global.conc_program_id,

9288: ),
9289: to_sequence_id,
9290: fnd_global.conc_request_id,
9291: NULL,
9292: fnd_global.conc_program_id,
9293: sysdate,
9294: bic.wip_supply_type,
9295: DECODE (rto_flag, 'Y', 2, bic.pick_components),
9296: DECODE (x_from_org_id,

Line 9733: fnd_global.conc_request_id,

9729: user_id,
9730: SYSDATE,
9731: user_id,
9732: 'E',
9733: fnd_global.conc_request_id,
9734: NULL,
9735: fnd_global.conc_program_id,
9736: sysdate
9737: FROM bom_components_b bcb,

Line 9735: fnd_global.conc_program_id,

9731: user_id,
9732: 'E',
9733: fnd_global.conc_request_id,
9734: NULL,
9735: fnd_global.conc_program_id,
9736: sysdate
9737: FROM bom_components_b bcb,
9738: mtl_system_items_b_kfv msbk1,
9739: bom_copy_explosions_v bev

Line 9862: fnd_global.conc_request_id,

9858: user_id,
9859: SYSDATE,
9860: user_id,
9861: 'E',
9862: fnd_global.conc_request_id,
9863: NULL,
9864: fnd_global.conc_program_id,
9865: sysdate
9866: FROM bom_components_b bcb,

Line 9864: fnd_global.conc_program_id,

9860: user_id,
9861: 'E',
9862: fnd_global.conc_request_id,
9863: NULL,
9864: fnd_global.conc_program_id,
9865: sysdate
9866: FROM bom_components_b bcb,
9867: mtl_system_items_b_kfv msbk1,
9868: bom_copy_explosions_v bev

Line 9927: fnd_global.conc_request_id,

9923: user_id,
9924: SYSDATE,
9925: user_id,
9926: 'E',
9927: fnd_global.conc_request_id,
9928: NULL,
9929: fnd_global.conc_program_id,
9930: sysdate
9931: FROM bom_components_b bcb,

Line 9929: fnd_global.conc_program_id,

9925: user_id,
9926: 'E',
9927: fnd_global.conc_request_id,
9928: NULL,
9929: fnd_global.conc_program_id,
9930: sysdate
9931: FROM bom_components_b bcb,
9932: mtl_system_items_b msib1, -- component
9933: bom_copy_explosions_v bev

Line 10029: fnd_global.conc_request_id,

10025: user_id,
10026: SYSDATE,
10027: user_id,
10028: 'E',
10029: fnd_global.conc_request_id,
10030: NULL,
10031: fnd_global.conc_program_id,
10032: sysdate
10033: FROM bom_components_b bcb,

Line 10031: fnd_global.conc_program_id,

10027: user_id,
10028: 'E',
10029: fnd_global.conc_request_id,
10030: NULL,
10031: fnd_global.conc_program_id,
10032: sysdate
10033: FROM bom_components_b bcb,
10034: bom_copy_explosions_v bev
10035: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 10128: fnd_global.conc_request_id,

10124: user_id,
10125: SYSDATE,
10126: user_id,
10127: 'E',
10128: fnd_global.conc_request_id,
10129: NULL,
10130: fnd_global.conc_program_id,
10131: sysdate
10132: FROM bom_components_b bcb,

Line 10130: fnd_global.conc_program_id,

10126: user_id,
10127: 'E',
10128: fnd_global.conc_request_id,
10129: NULL,
10130: fnd_global.conc_program_id,
10131: sysdate
10132: FROM bom_components_b bcb,
10133: mtl_system_items_b msib1,
10134: bom_copy_explosions_v bev

Line 10228: fnd_global.conc_request_id,

10224: user_id,
10225: SYSDATE,
10226: user_id,
10227: 'E',
10228: fnd_global.conc_request_id,
10229: NULL,
10230: fnd_global.conc_program_id,
10231: sysdate
10232: FROM bom_components_b bcb,

Line 10230: fnd_global.conc_program_id,

10226: user_id,
10227: 'E',
10228: fnd_global.conc_request_id,
10229: NULL,
10230: fnd_global.conc_program_id,
10231: sysdate
10232: FROM bom_components_b bcb,
10233: bom_copy_explosions_v bev
10234: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 10331: fnd_global.conc_request_id,

10327: user_id,
10328: SYSDATE,
10329: user_id,
10330: 'E',
10331: fnd_global.conc_request_id,
10332: NULL,
10333: fnd_global.conc_program_id,
10334: sysdate
10335: FROM bom_components_b bcb,

Line 10333: fnd_global.conc_program_id,

10329: user_id,
10330: 'E',
10331: fnd_global.conc_request_id,
10332: NULL,
10333: fnd_global.conc_program_id,
10334: sysdate
10335: FROM bom_components_b bcb,
10336: mtl_system_items_b msib
10337: WHERE bcb.bill_sequence_id = to_sequence_id

Line 10396: fnd_global.conc_request_id,

10392: user_id,
10393: SYSDATE,
10394: user_id,
10395: 'E',
10396: fnd_global.conc_request_id,
10397: NULL,
10398: fnd_global.conc_program_id,
10399: sysdate
10400: FROM bom_components_b bcb,

Line 10398: fnd_global.conc_program_id,

10394: user_id,
10395: 'E',
10396: fnd_global.conc_request_id,
10397: NULL,
10398: fnd_global.conc_program_id,
10399: sysdate
10400: FROM bom_components_b bcb,
10401: mtl_system_items_b msib
10402: WHERE bcb.bill_sequence_id = to_sequence_id

Line 10471: fnd_global.conc_request_id,

10467: user_id,
10468: SYSDATE,
10469: user_id,
10470: 'E',
10471: fnd_global.conc_request_id,
10472: NULL,
10473: fnd_global.conc_program_id,
10474: sysdate
10475: FROM bom_components_b bcb,

Line 10473: fnd_global.conc_program_id,

10469: user_id,
10470: 'E',
10471: fnd_global.conc_request_id,
10472: NULL,
10473: fnd_global.conc_program_id,
10474: sysdate
10475: FROM bom_components_b bcb,
10476: bom_copy_explosions_v bev
10477: WHERE bcb.bill_sequence_id = x_from_sequence_id

Line 10802: fnd_global.conc_request_id,

10798: user_id,
10799: SYSDATE,
10800: user_id,
10801: 'E',
10802: fnd_global.conc_request_id,
10803: NULL,
10804: fnd_global.conc_program_id,
10805: sysdate
10806: FROM bom_components_b bcb,

Line 10804: fnd_global.conc_program_id,

10800: user_id,
10801: 'E',
10802: fnd_global.conc_request_id,
10803: NULL,
10804: fnd_global.conc_program_id,
10805: sysdate
10806: FROM bom_components_b bcb,
10807: mtl_system_items_b msib1,
10808: mtl_system_items_b msib2

Line 10856: fnd_global.conc_request_id,

10852: user_id,
10853: SYSDATE,
10854: user_id,
10855: 'E',
10856: fnd_global.conc_request_id,
10857: NULL,
10858: fnd_global.conc_program_id,
10859: sysdate
10860: FROM bom_components_b bcb,

Line 10858: fnd_global.conc_program_id,

10854: user_id,
10855: 'E',
10856: fnd_global.conc_request_id,
10857: NULL,
10858: fnd_global.conc_program_id,
10859: sysdate
10860: FROM bom_components_b bcb,
10861: mtl_system_items_b msib1,
10862: mtl_system_items_b msib2

Line 10911: fnd_global.conc_request_id,

10907: user_id,
10908: SYSDATE,
10909: user_id,
10910: 'E',
10911: fnd_global.conc_request_id,
10912: NULL,
10913: fnd_global.conc_program_id,
10914: sysdate
10915: FROM bom_components_b bcb,

Line 10913: fnd_global.conc_program_id,

10909: user_id,
10910: 'E',
10911: fnd_global.conc_request_id,
10912: NULL,
10913: fnd_global.conc_program_id,
10914: sysdate
10915: FROM bom_components_b bcb,
10916: mtl_system_items_b msib1, -- Comp
10917: mtl_system_items_b msib2 -- Structure

Line 10966: fnd_global.conc_request_id,

10962: user_id,
10963: SYSDATE,
10964: user_id,
10965: 'E',
10966: fnd_global.conc_request_id,
10967: NULL,
10968: fnd_global.conc_program_id,
10969: sysdate
10970: FROM bom_components_b bcb,

Line 10968: fnd_global.conc_program_id,

10964: user_id,
10965: 'E',
10966: fnd_global.conc_request_id,
10967: NULL,
10968: fnd_global.conc_program_id,
10969: sysdate
10970: FROM bom_components_b bcb,
10971: mtl_system_items_b msib1, -- Comp
10972: mtl_system_items_b msib2 -- Structure

Line 11022: fnd_global.conc_request_id,

11018: user_id,
11019: SYSDATE,
11020: user_id,
11021: 'E',
11022: fnd_global.conc_request_id,
11023: NULL,
11024: fnd_global.conc_program_id,
11025: sysdate
11026: FROM bom_components_b bcb,

Line 11024: fnd_global.conc_program_id,

11020: user_id,
11021: 'E',
11022: fnd_global.conc_request_id,
11023: NULL,
11024: fnd_global.conc_program_id,
11025: sysdate
11026: FROM bom_components_b bcb,
11027: mtl_system_items_b msib1, -- Comp
11028: mtl_system_items_b msib2 -- Structure

Line 11160: fnd_global.conc_request_id,

11156: ref_designator_comment,
11157: x_e_change_notice,
11158: bic.component_sequence_id,
11159: x_acd_type,
11160: fnd_global.conc_request_id,
11161: NULL,
11162: fnd_global.conc_program_id,
11163: sysdate,
11164: brd.attribute_category,

Line 11162: fnd_global.conc_program_id,

11158: bic.component_sequence_id,
11159: x_acd_type,
11160: fnd_global.conc_request_id,
11161: NULL,
11162: fnd_global.conc_program_id,
11163: sysdate,
11164: brd.attribute_category,
11165: brd.attribute1,
11166: brd.attribute2,

Line 11249: fnd_global.conc_request_id,

11245: MSI.primary_unit_of_measure)) Sub_Comp_qty,
11246: bic.component_sequence_id,
11247: x_acd_type,
11248: x_e_change_notice,
11249: fnd_global.conc_request_id,
11250: NULL,
11251: fnd_global.conc_program_id,
11252: sysdate,
11253: bsc.attribute_category,

Line 11251: fnd_global.conc_program_id,

11247: x_acd_type,
11248: x_e_change_notice,
11249: fnd_global.conc_request_id,
11250: NULL,
11251: fnd_global.conc_program_id,
11252: sysdate,
11253: bsc.attribute_category,
11254: bsc.attribute1,
11255: bsc.attribute2,

Line 11416: fnd_global.conc_request_id,

11412: bco.attribute12,
11413: bco.attribute13,
11414: bco.attribute14,
11415: bco.attribute15,
11416: fnd_global.conc_request_id,
11417: NULL,
11418: fnd_global.conc_program_id,
11419: sysdate
11420: FROM bom_component_operations bco,

Line 11418: fnd_global.conc_program_id,

11414: bco.attribute14,
11415: bco.attribute15,
11416: fnd_global.conc_request_id,
11417: NULL,
11418: fnd_global.conc_program_id,
11419: sysdate
11420: FROM bom_component_operations bco,
11421: bom_components_b bic,
11422: bom_operation_sequences bos,

Line 11462: fnd_global.conc_program_id,

11458: SYSDATE,
11459: user_id,
11460: user_id,
11461: NULL,
11462: fnd_global.conc_program_id,
11463: sysdate,
11464: fnd_global.conc_request_id
11465: FROM bom_dependent_desc_elements bdde
11466: WHERE bdde.bill_sequence_id = x_from_sequence_id

Line 11464: fnd_global.conc_request_id

11460: user_id,
11461: NULL,
11462: fnd_global.conc_program_id,
11463: sysdate,
11464: fnd_global.conc_request_id
11465: FROM bom_dependent_desc_elements bdde
11466: WHERE bdde.bill_sequence_id = x_from_sequence_id
11467: AND ((itm_type = model
11468: AND EXISTS (

Line 11521: fnd_global.conc_request_id,

11517: user_id,
11518: SYSDATE,
11519: user_id,
11520: 'E',
11521: fnd_global.conc_request_id,
11522: NULL,
11523: fnd_global.conc_program_id,
11524: sysdate
11525: );

Line 11523: fnd_global.conc_program_id,

11519: user_id,
11520: 'E',
11521: fnd_global.conc_request_id,
11522: NULL,
11523: fnd_global.conc_program_id,
11524: sysdate
11525: );
11526: WHEN common_error
11527: THEN

Line 11564: fnd_global.conc_request_id,

11560: user_id,
11561: SYSDATE,
11562: user_id,
11563: 'E',
11564: fnd_global.conc_request_id,
11565: NULL,
11566: fnd_global.conc_program_id,
11567: sysdate
11568: );

Line 11566: fnd_global.conc_program_id,

11562: user_id,
11563: 'E',
11564: fnd_global.conc_request_id,
11565: NULL,
11566: fnd_global.conc_program_id,
11567: sysdate
11568: );
11569: WHEN OTHERS
11570: THEN

Line 11600: x_program_id => fnd_global.conc_program_id,

11596: x_to_pk5_value => '',
11597: x_created_by => p_user_id,
11598: x_last_update_login => '',
11599: x_program_application_id => '',
11600: x_program_id => fnd_global.conc_program_id,
11601: x_request_id => fnd_global.conc_request_id
11602: );
11603: END;
11604:

Line 11601: x_request_id => fnd_global.conc_request_id

11597: x_created_by => p_user_id,
11598: x_last_update_login => '',
11599: x_program_application_id => '',
11600: x_program_id => fnd_global.conc_program_id,
11601: x_request_id => fnd_global.conc_request_id
11602: );
11603: END;
11604:
11605: FUNCTION get_comp_type_rule_message(p_msg_name IN VARCHAR2,