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.ZX_AR_ACTG_POPULATE_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 353: FROM zx_rep_trx_detail_t zx_dtl,

349: ZX_ACTG.ACTG_HEADER_ID,
350: ZX_ACTG.ACTG_EVENT_ID,
351: -- ZX_ACTG.ACTG_ENTITY_ID,
352: ZX_ACTG.ACTG_LINE_CCID
353: FROM zx_rep_trx_detail_t zx_dtl,
354: zx_rep_actg_ext_t zx_actg
355: WHERE EXTRACT_SOURCE_LEDGER = 'AR'
356: AND zx_dtl.detail_tax_line_id = zx_actg.detail_tax_line_id
357: AND zx_dtl.request_id = c_request_id;

Line 2137: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;

2133:
2134:
2135: /*PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
2136:
2137: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
2138: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
2139: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2140: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2141:

Line 2138: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;

2134:
2135: /*PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
2136:
2137: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
2138: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
2139: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2140: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2141:
2142: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;

Line 2139: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

2135: /*PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
2136:
2137: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
2138: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
2139: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2140: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2141:
2142: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2143: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

Line 2140: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

2136:
2137: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
2138: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
2139: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2140: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2141:
2142: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2143: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
2144: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

Line 2142: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;

2138: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
2139: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2140: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2141:
2142: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2143: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
2144: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
2145: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
2146:

Line 2143: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

2139: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2140: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2141:
2142: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2143: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
2144: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
2145: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
2146:
2147: l_bill_ship varchar2(30);

Line 2144: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

2140: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2141:
2142: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2143: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
2144: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
2145: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
2146:
2147: l_bill_ship varchar2(30);
2148:

Line 2145: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;

2141:
2142: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2143: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
2144: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
2145: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
2146:
2147: l_bill_ship varchar2(30);
2148:
2149: l_tbl_index_party BINARY_INTEGER;

Line 2154: (c_ptp_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_TAX_PROF_ID%TYPE) IS

2150: l_tbl_index_site BINARY_INTEGER;
2151: l_tbl_index_cust BINARY_INTEGER;
2152:
2153: CURSOR party_id_cur
2154: (c_ptp_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_TAX_PROF_ID%TYPE) IS
2155: SELECT party_id
2156: FROM zx_party_tax_profile
2157: WHERE PARTY_TAX_PROFILE_ID = c_ptp_id
2158: AND party_type_code = 'THIRD_PARTY';

Line 2161: (c_ptp_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_SITE_TAX_PROF_ID%TYPE) IS

2157: WHERE PARTY_TAX_PROFILE_ID = c_ptp_id
2158: AND party_type_code = 'THIRD_PARTY';
2159:
2160: CURSOR party_site_id_cur
2161: (c_ptp_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_SITE_TAX_PROF_ID%TYPE) IS
2162: SELECT party_id
2163: FROM zx_party_tax_profile
2164: WHERE PARTY_TAX_PROFILE_ID = c_ptp_site_id
2165: AND party_type_code = 'THIRD_PARTY_SITE';

Line 2170: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS

2166:
2167: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
2168:
2169: CURSOR party_profile_id_cur
2170: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
2171: SELECT party_tax_profile_id
2172: FROM zx_party_tax_profile
2173: WHERE party_id = c_party_id
2174: AND party_type_code = 'THIRD_PARTY';

Line 2178: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS

2174: AND party_type_code = 'THIRD_PARTY';
2175:
2176:
2177: CURSOR site_profile_id_cur
2178: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
2179: SELECT party_tax_profile_id
2180: FROM zx_party_tax_profile
2181: WHERE party_id = c_party_site_id
2182: AND party_type_code = 'THIRD_PARTY_SITE';

Line 2184: CURSOR party_cur (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS

2180: FROM zx_party_tax_profile
2181: WHERE party_id = c_party_site_id
2182: AND party_type_code = 'THIRD_PARTY_SITE';
2183:
2184: CURSOR party_cur (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
2185: select SUBSTRB(PARTY.PARTY_NAME,1,240) ,
2186: DECODE(PARTY.PARTY_TYPE,
2187: 'ORGANIZATION',
2188: PARTY.ORGANIZATION_NAME_PHONETIC,

Line 2198: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS

2194: PARTY.PARTY_NUMBER
2195: FROM HZ_PARTIES PARTY
2196: WHERE PARTY.PARTY_ID = c_party_id;
2197:
2198: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
2199: select LOC.CITY,
2200: LOC.COUNTY,
2201: LOC.STATE,
2202: LOC.PROVINCE,

Line 2214: CURSOR cust_acct_cur (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,

2210: HZ_LOCATIONS LOC
2211: WHERE party_site.party_site_id = c_party_site_id
2212: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
2213:
2214: CURSOR cust_acct_cur (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,
2215: c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,
2216: c_ship_bill varchar2) IS
2217: SELECT acct.account_number,
2218: acct.global_attribute10,

Line 2215: c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,

2211: WHERE party_site.party_site_id = c_party_site_id
2212: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
2213:
2214: CURSOR cust_acct_cur (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,
2215: c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,
2216: c_ship_bill varchar2) IS
2217: SELECT acct.account_number,
2218: acct.global_attribute10,
2219: acct.global_attribute12,

Line 2233: CURSOR migrated_party_cur (c_cust_acct_id ZX_REP_TRX_DETAIL_T.BILLING_TRADING_PARTNER_ID%TYPE) IS

2229: and acct_site.PARTY_SITE_ID = c_party_site_id
2230: and ACCT.PARTY_ID = c_party_id
2231: and site_use.site_use_code = c_ship_bill;
2232:
2233: CURSOR migrated_party_cur (c_cust_acct_id ZX_REP_TRX_DETAIL_T.BILLING_TRADING_PARTNER_ID%TYPE) IS
2234: SELECT party.party_id
2235: FROM HZ_PARTIES PARTY,
2236: hz_cust_accounts acct
2237: WHERE PARTY.PARTY_ID = acct.party_id

Line 2241: CURSOR migrated_party_site_cur ( c_cust_acct_site_id ZX_REP_TRX_DETAIL_T.BILLING_TP_ADDRESS_ID%TYPE) IS

2237: WHERE PARTY.PARTY_ID = acct.party_id
2238: And acct.cust_account_id = c_cust_acct_id;
2239:
2240:
2241: CURSOR migrated_party_site_cur ( c_cust_acct_site_id ZX_REP_TRX_DETAIL_T.BILLING_TP_ADDRESS_ID%TYPE) IS
2242: SELECT PARTY_SITE.party_site_id
2243: FROM HZ_PARTY_SITES PARTY_SITE,
2244: hz_cust_acct_sites_all acct_site
2245: WHERE acct_site.cust_acct_site_id = c_cust_acct_site_id

Line 2606: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;

2602:
2603:
2604: PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
2605:
2606: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
2607: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
2608: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2609: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2610:

Line 2607: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;

2603:
2604: PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
2605:
2606: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
2607: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
2608: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2609: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2610:
2611: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;

Line 2608: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

2604: PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
2605:
2606: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
2607: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
2608: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2609: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2610:
2611: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2612: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

Line 2609: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

2605:
2606: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
2607: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
2608: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2609: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2610:
2611: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2612: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
2613: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

Line 2611: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;

2607: l_bill_to_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
2608: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2609: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2610:
2611: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2612: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
2613: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
2614: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
2615:

Line 2612: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

2608: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
2609: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2610:
2611: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2612: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
2613: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
2614: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
2615:
2616: l_bill_ship varchar2(30);

Line 2613: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

2609: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
2610:
2611: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2612: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
2613: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
2614: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
2615:
2616: l_bill_ship varchar2(30);
2617:

Line 2614: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;

2610:
2611: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
2612: l_ship_to_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
2613: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
2614: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
2615:
2616: l_bill_ship varchar2(30);
2617:
2618: l_tbl_index_party BINARY_INTEGER;

Line 2623: (c_ptp_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_TAX_PROF_ID%TYPE) IS

2619: l_tbl_index_site BINARY_INTEGER;
2620: l_tbl_index_cust BINARY_INTEGER;
2621:
2622: CURSOR party_id_from_ptp_cur
2623: (c_ptp_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_TAX_PROF_ID%TYPE) IS
2624: SELECT party_id
2625: FROM zx_party_tax_profile
2626: WHERE PARTY_TAX_PROFILE_ID = c_ptp_id
2627: AND party_type_code = 'THIRD_PARTY';

Line 2630: (c_ptp_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_SITE_TAX_PROF_ID%TYPE) IS

2626: WHERE PARTY_TAX_PROFILE_ID = c_ptp_id
2627: AND party_type_code = 'THIRD_PARTY';
2628:
2629: CURSOR party_site_id_from_ptp_cur
2630: (c_ptp_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_SITE_TAX_PROF_ID%TYPE) IS
2631: SELECT party_id
2632: FROM zx_party_tax_profile
2633: WHERE PARTY_TAX_PROFILE_ID = c_ptp_site_id
2634: AND party_type_code = 'THIRD_PARTY_SITE';

Line 2639: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS

2635:
2636: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
2637:
2638: CURSOR party_profile_id_cur
2639: (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
2640: SELECT party_tax_profile_id
2641: FROM zx_party_tax_profile
2642: WHERE party_id = c_party_id
2643: AND party_type_code = 'THIRD_PARTY';

Line 2647: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS

2643: AND party_type_code = 'THIRD_PARTY';
2644:
2645:
2646: CURSOR site_profile_id_cur
2647: (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
2648: SELECT party_tax_profile_id
2649: FROM zx_party_tax_profile
2650: WHERE party_id = c_party_site_id
2651: AND party_type_code = 'THIRD_PARTY_SITE';

Line 2653: CURSOR party_cur (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS

2649: FROM zx_party_tax_profile
2650: WHERE party_id = c_party_site_id
2651: AND party_type_code = 'THIRD_PARTY_SITE';
2652:
2653: CURSOR party_cur (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
2654: select SUBSTRB(PARTY.PARTY_NAME,1,240) ,
2655: DECODE(PARTY.PARTY_TYPE,
2656: 'ORGANIZATION',
2657: PARTY.ORGANIZATION_NAME_PHONETIC,

Line 2669: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS

2665: PARTY.TAX_REFERENCE
2666: FROM HZ_PARTIES PARTY
2667: WHERE PARTY.PARTY_ID = c_party_id;
2668:
2669: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
2670: select LOC.CITY,
2671: LOC.COUNTY,
2672: LOC.STATE,
2673: LOC.PROVINCE,

Line 2685: CURSOR cust_acct_cur (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,

2681: HZ_LOCATIONS LOC
2682: WHERE party_site.party_site_id = c_party_site_id
2683: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
2684:
2685: CURSOR cust_acct_cur (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,
2686: c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,
2687: c_ship_bill varchar2) IS
2688: SELECT acct.account_number,
2689: acct.global_attribute10,

Line 2686: c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,

2682: WHERE party_site.party_site_id = c_party_site_id
2683: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
2684:
2685: CURSOR cust_acct_cur (c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,
2686: c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,
2687: c_ship_bill varchar2) IS
2688: SELECT acct.account_number,
2689: acct.global_attribute10,
2690: acct.global_attribute12,

Line 2704: CURSOR party_id_cur (c_cust_acct_id ZX_REP_TRX_DETAIL_T.BILLING_TRADING_PARTNER_ID%TYPE) IS

2700: and acct_site.PARTY_SITE_ID = c_party_site_id
2701: and ACCT.PARTY_ID = c_party_id
2702: and site_use.site_use_code = c_ship_bill;
2703:
2704: CURSOR party_id_cur (c_cust_acct_id ZX_REP_TRX_DETAIL_T.BILLING_TRADING_PARTNER_ID%TYPE) IS
2705: SELECT acct.party_id
2706: FROM hz_cust_accounts acct
2707: WHERE acct.cust_account_id = c_cust_acct_id;
2708:

Line 2709: CURSOR party_site_id_cur ( c_cust_site_use_id ZX_REP_TRX_DETAIL_T.BILLING_TP_SITE_ID%TYPE) IS

2705: SELECT acct.party_id
2706: FROM hz_cust_accounts acct
2707: WHERE acct.cust_account_id = c_cust_acct_id;
2708:
2709: CURSOR party_site_id_cur ( c_cust_site_use_id ZX_REP_TRX_DETAIL_T.BILLING_TP_SITE_ID%TYPE) IS
2710: SELECT acct_site.party_site_id
2711: FROM hz_cust_acct_sites_all acct_site,
2712: hz_cust_site_uses_all site_use
2713: WHERE acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 3182: UPDATE ZX_REP_TRX_DETAIL_T SET

3178: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_DETAIL_T(+)');
3179: END IF;
3180:
3181: FORALL i in 1..p_count
3182: UPDATE ZX_REP_TRX_DETAIL_T SET
3183: REP_CONTEXT_ID = G_REP_CONTEXT_ID,
3184: BILLING_TP_NUMBER = GT_BILLING_TP_NUMBER(i),
3185: BILLING_TP_TAX_REG_NUM = GT_BILLING_TP_TAX_REG_NUM(i),
3186: BILLING_TP_TAXPAYER_ID = GT_BILLING_TP_TAXPAYER_ID(i),