[Home] [Help]
234: p_le_id IN NUMBER,
235: x_provider_id OUT NOCOPY NUMBER,
236: x_return_status OUT NOCOPY VARCHAR2) is
237:
238: l_use_Le_As_Subscriber_Flag zx_party_tax_profile.Use_Le_As_Subscriber_Flag%type;
239: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;
240: l_provider_id number;
241: l_return_status varchar2(50);
242: x_msg_count VARCHAR2(50);
235: x_provider_id OUT NOCOPY NUMBER,
236: x_return_status OUT NOCOPY VARCHAR2) is
237:
238: l_use_Le_As_Subscriber_Flag zx_party_tax_profile.Use_Le_As_Subscriber_Flag%type;
239: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;
240: l_provider_id number;
241: l_return_status varchar2(50);
242: x_msg_count VARCHAR2(50);
243: x_msg_data VARCHAR2(50);
257: SELECT Use_Le_As_Subscriber_Flag,
258: party_tax_profile_id
259: INTO l_use_Le_As_Subscriber_Flag,
260: l_party_tax_profile_id
261: FROM zx_party_tax_profile
262: WHERE party_id = p_org_id
263: AND Party_Type_Code = 'OU';
264: exception when others then
265: /* This error should be: not able to find PTP for the input OU */
816:
817: For O2C products, the information can be derived as follows.
818: Party Type PTP known Other Info Derivation Logic
819: --------------- ----- ----------- ----------------
820: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
821:
822: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
823: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
824:
821:
822: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
823: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
824:
825: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
826: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
827: Rel 12 with new partner integration, he must do legal to business association using LE form.
828: That would create a PTP for the first party inv org.
829: Hence, there will be a record in HZ_PARTIES and is correct to derive info from HZ_PARTIES.
833: -------------------------------------------------------------------------------------------
834: For P2P products, the information can be derived as follows.
835: Party Type PTP known Other Info Derivation Logic
836: --------------- ----- ----------- ----------------
837: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
838: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
839: Rel 12 with new partner integration, he must do legal to business association using LE form.
840: That would create a PTP for the first party inv org.
841: Hence, there will definitely be record in HZ_PARTIES.
841: Hence, there will definitely be record in HZ_PARTIES.
842:
843: SHIP/BILL TO N NULL (PTP is always expected)
844:
845: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
846:
847: SHIP/BILL FROM N SHIP_THIRD_PTY_ACCT_ID Via PO_VENDORS
848: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of VENDOR_ID.
849:
868: pty.party_number
869: INTO ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NAME(i),
870: ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NUMBER(i)
871: FROM hz_parties pty,
872: zx_party_tax_profile ptp
873: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_TAX_PROF_ID(i)
874: AND ptp.party_id = pty.party_id;
875: EXCEPTION WHEN OTHERS THEN
876: ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NAME(i) := NULL;
941: pty.party_number
942: INTO ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NAME(i),
943: ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NUMBER(i)
944: FROM hz_parties pty,
945: zx_party_tax_profile ptp
946: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_TAX_PROF_ID(i)
947: AND ptp.party_id = pty.party_id;
948: EXCEPTION WHEN OTHERS THEN
949: ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NAME(i) := NULL;
969: pty.party_number
970: INTO ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_NAME(i),
971: ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_NUMBER(i)
972: FROM hz_parties pty,
973: zx_party_tax_profile ptp
974: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_TAX_PROF_ID(i)
975: AND ptp.party_id = pty.party_id;
976: EXCEPTION WHEN OTHERS THEN
977: ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_NAME(i) := NULL;
1006: pty.party_number
1007: INTO ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_NAME(i),
1008: ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_NUMBER(i)
1009: FROM hz_parties pty,
1010: zx_party_tax_profile ptp
1011: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_TAX_PROF_ID(i)
1012: AND ptp.party_id = pty.party_id;
1013: EXCEPTION WHEN OTHERS THEN
1014: ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_NAME(i) := NULL;
1052: BEGIN
1053: BEGIN
1054: SELECT ptp.party_tax_profile_id
1055: INTO x_party_tax_profile_id
1056: FROM hz_cust_site_uses_all siteuse, hz_cust_acct_sites_all site, hz_cust_accounts acct, zx_party_tax_profile ptp
1057: WHERE siteuse.site_use_id = p_site_use_id and
1058: siteuse.cust_acct_site_id = site.cust_acct_site_id and
1059: site.cust_account_id = acct.cust_account_id and
1060: acct.party_id = ptp.party_id and
2331: Begin
2332: SELECT pty.party_name
2333: INTO l_srvc_prvdr_name
2334: FROM HZ_PARTIES pty,
2335: ZX_PARTY_TAX_PROFILE ptp
2336: WHERE ptp.party_tax_profile_id =p_srvc_prvdr_id
2337: AND pty.party_id = ptp.party_id
2338: AND ptp.provider_type_code in ('BOTH', 'SERVICE');
2339: Exception
2667: Begin
2668: SELECT pty.party_name
2669: INTO l_srvc_prvdr_name
2670: FROM HZ_PARTIES pty,
2671: ZX_PARTY_TAX_PROFILE ptp
2672: WHERE ptp.party_tax_profile_id =p_srvc_prvdr_id
2673: AND pty.party_id = ptp.party_id
2674: AND ptp.provider_type_code in ('BOTH', 'SERVICE');
2675: Exception