eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on HZ_PARTIES

Line 778: FROM hz_parties

774:
775:
776: CURSOR Get_party_number is
777: SELECT party_number
778: FROM hz_parties
779: WHERE party_id = p_party_id;
780:
781: l_party_number hz_parties.party_number%type;
782: --

Line 781: l_party_number hz_parties.party_number%type;

777: SELECT party_number
778: FROM hz_parties
779: WHERE party_id = p_party_id;
780:
781: l_party_number hz_parties.party_number%type;
782: --
783: --
784: -- For Events
785:

Line 2402: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';

2398: -- Start bug 9823087
2399: For i in c_instance_party_owner loop
2400: k := k + 1;
2401: csi_txn_party_detail_tbl(k).instance_party_id := i.instance_party_id;
2402: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';
2403: csi_txn_party_detail_tbl(k).party_source_id := l_internal_party_id;
2404: csi_txn_party_detail_tbl(k).relationship_type_code := i.relationship_type_code;
2405: csi_txn_party_detail_tbl(k).txn_line_details_index := k;
2406: csi_txn_party_detail_tbl(k).contact_flag := 'N';

Line 2413: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';

2409:
2410: For i in c_instance_party loop
2411: k := k + 1;
2412: csi_txn_party_detail_tbl(k).instance_party_id := i.instance_party_id;
2413: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';
2414: csi_txn_party_detail_tbl(k).party_source_id := l_internal_party_id;
2415: csi_txn_party_detail_tbl(k).relationship_type_code := i.relationship_type_code;
2416: csi_txn_party_detail_tbl(k).txn_line_details_index := k;
2417: csi_txn_party_detail_tbl(k).contact_flag := 'N';

Line 2424: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';

2420:
2421: /*For i in c_instance_party loop
2422: k := k + 1;
2423: csi_txn_party_detail_tbl(k).instance_party_id := i.instance_party_id;
2424: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';
2425: csi_txn_party_detail_tbl(k).party_source_id := l_internal_party_id;
2426: csi_txn_party_detail_tbl(k).relationship_type_code := i.relationship_type_code;
2427: csi_txn_party_detail_tbl(k).txn_line_details_index := k;
2428: csi_txn_party_detail_tbl(k).contact_flag := 'N';

Line 2454: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2451: END;
2452:
2453: csi_txn_party_detail_tbl(1).instance_party_id := l_instance_party_id;
2454: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';
2455: csi_txn_party_detail_tbl(1).party_source_id := l_internal_party_id;
2456: csi_txn_party_detail_tbl(1).relationship_type_code := 'OWNER';
2457: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
2458: csi_txn_party_detail_tbl(1).contact_flag := 'N';*/

Line 2529: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';

2525:
2526: /*For i in c_instance_party1 loop
2527: k := k + 1;
2528: csi_txn_party_detail_tbl(k).instance_party_id := i.instance_party_id;
2529: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';
2530: csi_txn_party_detail_tbl(k).party_source_id := l_internal_party_id;
2531: csi_txn_party_detail_tbl(k).relationship_type_code := i.relationship_type_code;
2532: csi_txn_party_detail_tbl(k).txn_line_details_index := k;
2533: csi_txn_party_detail_tbl(k).contact_flag := 'N';

Line 2539: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';

2535:
2536: For i in c_instance_party1_owner loop
2537: k := k + 1;
2538: csi_txn_party_detail_tbl(k).instance_party_id := i.instance_party_id;
2539: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';
2540: csi_txn_party_detail_tbl(k).party_source_id := l_internal_party_id;
2541: csi_txn_party_detail_tbl(k).relationship_type_code := i.relationship_type_code;
2542: csi_txn_party_detail_tbl(k).txn_line_details_index := k;
2543: csi_txn_party_detail_tbl(k).contact_flag := 'N';

Line 2549: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';

2545:
2546: For i in c_instance_party1 loop
2547: k := k + 1;
2548: csi_txn_party_detail_tbl(k).instance_party_id := i.instance_party_id;
2549: csi_txn_party_detail_tbl(k).party_source_table := 'HZ_PARTIES';
2550: csi_txn_party_detail_tbl(k).party_source_id := l_internal_party_id;
2551: csi_txn_party_detail_tbl(k).relationship_type_code := i.relationship_type_code;
2552: csi_txn_party_detail_tbl(k).txn_line_details_index := k;
2553: csi_txn_party_detail_tbl(k).contact_flag := 'N';

Line 2579: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

2575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;*/
2576: END;
2577: /*
2578: csi_txn_party_detail_tbl(1).instance_party_id := l_instance_party_id;
2579: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';
2580: csi_txn_party_detail_tbl(1).party_source_id := l_internal_party_id;
2581: csi_txn_party_detail_tbl(1).relationship_type_code := 'OWNER';
2582: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
2583: csi_txn_party_detail_tbl(1).contact_flag := 'N';*/

Line 2595: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

2591:
2592: ELSE -- shipment line
2593: IF l_src_change_owner = 'Y' THEN
2594: -- Create Party record
2595: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';
2596: csi_txn_party_detail_tbl(1).party_source_id := EstDtlTab(i).customer_id;
2597: csi_txn_party_detail_tbl(1).relationship_type_code := 'OWNER';
2598: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
2599: csi_txn_party_detail_tbl(1).contact_flag := 'N';

Line 3429: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

3425: FROM hz_cust_accounts
3426: WHERE cust_account_id = l_account_id);
3427:
3428: csi_txn_party_detail_tbl(1).instance_party_id := l_instance_party_id;
3429: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';
3430: csi_txn_party_detail_tbl(1).party_source_id := l_internal_party_id;
3431: csi_txn_party_detail_tbl(1).relationship_type_code := 'OWNER';
3432: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
3433: csi_txn_party_detail_tbl(1).contact_flag := 'N';

Line 3452: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';

3448:
3449: ELSE -- shipment line
3450: IF l_src_change_owner = 'Y' THEN
3451: -- Create Party record
3452: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';
3453: csi_txn_party_detail_tbl(1).party_source_id := EstDtlTab(i).customer_id;
3454: csi_txn_party_detail_tbl(1).relationship_type_code := 'OWNER';
3455: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
3456: csi_txn_party_detail_tbl(1).contact_flag := 'N';