DBA Data[Home] [Help]

APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_GEN_UTILITY_PVT

Line 3230: csi_gen_utility_pvt.populate_install_param_rec;

3226:
3227: truncate_table(l_object_name);
3228:
3229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3230: csi_gen_utility_pvt.populate_install_param_rec;
3231: END IF;
3232:
3233: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
3234:

Line 3435: csi_gen_utility_pvt.populate_install_param_rec;

3431: INTO l_release
3432: FROM sys.dual;
3433: --
3434: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3435: csi_gen_utility_pvt.populate_install_param_rec;
3436: END IF;
3437: --
3438: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
3439: --

Line 3719: csi_gen_utility_pvt.populate_install_param_rec;

3715:
3716: BEGIN
3717:
3718: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3719: csi_gen_utility_pvt.populate_install_param_rec;
3720: END IF;
3721: --
3722: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
3723: --

Line 3809: csi_gen_utility_pvt.populate_install_param_rec;

3805:
3806: log(date_time_stamp||' begin pump_err_missing_txn');
3807:
3808: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3809: csi_gen_utility_pvt.populate_install_param_rec;
3810: END IF;
3811: --
3812: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
3813: --

Line 4062: csi_gen_utility_pvt.populate_install_param_rec;

4058: INTO l_release
4059: FROM sys.dual;
4060: --
4061: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4062: csi_gen_utility_pvt.populate_install_param_rec;
4063: END IF;
4064: --
4065: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
4066: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

Line 6128: csi_gen_utility_pvt.populate_install_param_rec;

6124: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
6125: AND haou.organization_id = mssi.organization_id;
6126: ELSIF l_instance_rec.location_type_code = 'WIP' THEN
6127: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6128: csi_gen_utility_pvt.populate_install_param_rec;
6129: END IF;
6130: --
6131: l_instance_rec.location_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
6132: END IF;

Line 6233: csi_gen_utility_pvt.populate_install_param_rec;

6229: END IF;
6230:
6231: IF l_instance_rec.location_type_code = 'WIP' THEN
6232: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6233: csi_gen_utility_pvt.populate_install_param_rec;
6234: END IF;
6235: --
6236: l_instance_rec.location_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
6237: END IF;

Line 6898: csi_gen_utility_pvt.populate_install_param_rec;

6894: x_return_status := fnd_api.g_ret_sts_success;
6895:
6896: IF p_diag_txn_rec.inst_id is not null THEN
6897: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6898: csi_gen_utility_pvt.populate_install_param_rec;
6899: END IF;
6900: --
6901: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;
6902: --

Line 7516: csi_gen_utility_pvt.populate_install_param_rec;

7512:
7513: x_return_status := fnd_api.g_ret_sts_success;
7514:
7515: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7516: csi_gen_utility_pvt.populate_install_param_rec;
7517: END IF;
7518: --
7519: l_project_location_id := csi_datastructures_pub.g_install_param_rec.project_location_id;
7520: --

Line 7624: csi_gen_utility_pvt.populate_install_param_rec;

7620:
7621: x_return_status := fnd_api.g_ret_sts_success;
7622:
7623: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7624: csi_gen_utility_pvt.populate_install_param_rec;
7625: END IF;
7626: --
7627: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7628: --

Line 7906: csi_gen_utility_pvt.populate_install_param_rec;

7902:
7903: x_return_status := fnd_api.g_ret_sts_success;
7904:
7905: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7906: csi_gen_utility_pvt.populate_install_param_rec;
7907: END IF;
7908: --
7909: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7910: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;

Line 8201: csi_gen_utility_pvt.populate_install_param_rec;

8197:
8198: x_return_status := fnd_api.g_ret_sts_success;
8199:
8200: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8201: csi_gen_utility_pvt.populate_install_param_rec;
8202: END IF;
8203: --
8204: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8205: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;

Line 8770: csi_gen_utility_pvt.populate_install_param_rec;

8766: WHERE transaction_type_id = 53
8767: AND default_flag = 'Y';
8768: --
8769: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8770: csi_gen_utility_pvt.populate_install_param_rec;
8771: END IF;
8772: --
8773: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
8774:

Line 8919: csi_gen_utility_pvt.populate_install_param_rec;

8915: INTO l_release
8916: FROM sys.dual;
8917: --
8918: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8919: csi_gen_utility_pvt.populate_install_param_rec;
8920: END IF;
8921: --
8922: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8923: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

Line 10261: csi_gen_utility_pvt.populate_install_param_rec;

10257: return;
10258: end;
10259: --
10260: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10261: csi_gen_utility_pvt.populate_install_param_rec;
10262: END IF;
10263: --
10264: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
10265: --

Line 10766: csi_gen_utility_pvt.populate_install_param_rec;

10762: ,1
10763: );
10764: --
10765: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10766: csi_gen_utility_pvt.populate_install_param_rec;
10767: END IF;
10768: --
10769: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
10770: --

Line 12230: csi_gen_utility_pvt.populate_install_param_rec;

12226: Comp_error EXCEPTION;
12227: Process_next EXCEPTION;
12228: BEGIN
12229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
12230: csi_gen_utility_pvt.populate_install_param_rec;
12231: END IF;
12232: --
12233: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
12234: --

Line 12269: csi_gen_utility_pvt.populate_install_param_rec;

12265: Raise comp_error;
12266: End;
12267: -- Get the Internal Party ID
12268: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
12269: csi_gen_utility_pvt.populate_install_param_rec;
12270: END IF;
12271: --
12272: v_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
12273: --

Line 13402: csi_gen_utility_pvt.populate_install_param_rec;

13398:
13399: BEGIN
13400:
13401: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
13402: csi_gen_utility_pvt.populate_install_param_rec;
13403: END IF;
13404: --
13405: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
13406: --

Line 13658: csi_gen_utility_pvt.populate_install_param_rec;

13654: p_file_segment1 => 'csinonsy',
13655: p_file_segment2 => to_char(sysdate, 'hh24miss'));
13656: --
13657: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
13658: csi_gen_utility_pvt.populate_install_param_rec;
13659: END IF;
13660: --
13661: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
13662: --

Line 13697: csi_gen_utility_pvt.populate_install_param_rec;

13693: Raise comp_error;
13694: End;
13695: -- Get the Internal Party ID
13696: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
13697: csi_gen_utility_pvt.populate_install_param_rec;
13698: END IF;
13699: --
13700: v_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
13701: --

Line 15126: csi_gen_utility_pvt.populate_install_param_rec;

15122: out(l_message);
15123:
15124: --
15125: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
15126: csi_gen_utility_pvt.populate_install_param_rec;
15127: END IF;
15128: --
15129: l_ownership_override := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
15130: --

Line 15451: csi_gen_utility_pvt.populate_install_param_rec;

15447: WHERE transaction_type_id = 53
15448: AND default_flag = 'Y';
15449:
15450: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
15451: csi_gen_utility_pvt.populate_install_param_rec;
15452: END IF;
15453: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
15454:
15455: --Changed to use the BULK COLLECT for cursor for bug5248037--

Line 16486: csi_gen_utility_pvt.populate_install_param_rec;

16482: log(' parameter - Show Instances :'||p_show_instances);
16483: log(' parameter - Mode of execution :'||p_mode);
16484: --
16485: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
16486: csi_gen_utility_pvt.populate_install_param_rec;
16487: END IF;
16488: --
16489: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' OR
16490: csi_datastructures_pub.g_install_param_rec.freeze_flag = 'N' THEN