[Home] [Help]
232: p_le_id IN NUMBER,
233: x_provider_id OUT NOCOPY NUMBER,
234: x_return_status OUT NOCOPY VARCHAR2) is
235:
236: l_use_Le_As_Subscriber_Flag zx_party_tax_profile.Use_Le_As_Subscriber_Flag%type;
237: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;
238: l_provider_id number;
239: l_return_status varchar2(50);
240: x_msg_count VARCHAR2(50);
233: x_provider_id OUT NOCOPY NUMBER,
234: x_return_status OUT NOCOPY VARCHAR2) is
235:
236: l_use_Le_As_Subscriber_Flag zx_party_tax_profile.Use_Le_As_Subscriber_Flag%type;
237: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;
238: l_provider_id number;
239: l_return_status varchar2(50);
240: x_msg_count VARCHAR2(50);
241: x_msg_data VARCHAR2(50);
249: SELECT Use_Le_As_Subscriber_Flag,
250: party_tax_profile_id
251: INTO l_use_Le_As_Subscriber_Flag,
252: l_party_tax_profile_id
253: FROM zx_party_tax_profile
254: WHERE party_id = p_org_id
255: AND Party_Type_Code = 'OU';
256: exception when others then
257: /* This error should be: not able to find PTP for the input OU */
785:
786: For O2C products, the information can be derived as follows.
787: Party Type PTP known Other Info Derivation Logic
788: --------------- ----- ----------- ----------------
789: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
790:
791: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
792: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
793:
790:
791: SHIP/BILL TO N SHIP_THIRD_PTY_ACCT_ID Via HZ_CUST_ACCOUNTS, HZ_PARTIES
792: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS.
793:
794: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
795: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
796: Rel 12 with new partner integration, he must do legal to business association using LE form.
797: That would create a PTP for the first party inv org.
798: Hence, there will be a record in HZ_PARTIES and is correct to derive info from HZ_PARTIES.
802: -------------------------------------------------------------------------------------------
803: For P2P products, the information can be derived as follows.
804: Party Type PTP known Other Info Derivation Logic
805: --------------- ----- ----------- ----------------
806: SHIP/BILL TO Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
807: As per Desh's update in the bug, If a eBiz customer wants to pass first party inv org id in
808: Rel 12 with new partner integration, he must do legal to business association using LE form.
809: That would create a PTP for the first party inv org.
810: Hence, there will definitely be record in HZ_PARTIES.
810: Hence, there will definitely be record in HZ_PARTIES.
811:
812: SHIP/BILL TO N NULL (PTP is always expected)
813:
814: SHIP/BILL FROM Y Via ZX_PARTY_TAX_PROFILE, HZ_PARTIES
815:
816: SHIP/BILL FROM N SHIP_THIRD_PTY_ACCT_ID Via PO_VENDORS
817: In this case, SHIP_THIRD_PTY_ACCT_ID holds value of VENDOR_ID.
818:
837: pty.party_number
838: INTO ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NAME(i),
839: ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NUMBER(i)
840: FROM hz_parties pty,
841: zx_party_tax_profile ptp
842: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_TAX_PROF_ID(i)
843: AND ptp.party_id = pty.party_id;
844: EXCEPTION WHEN OTHERS THEN
845: ZX_PTNR_NEG_LINES_TAB.BILL_TO_PARTY_NAME(i) := NULL;
910: pty.party_number
911: INTO ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NAME(i),
912: ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NUMBER(i)
913: FROM hz_parties pty,
914: zx_party_tax_profile ptp
915: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_TAX_PROF_ID(i)
916: AND ptp.party_id = pty.party_id;
917: EXCEPTION WHEN OTHERS THEN
918: ZX_PTNR_NEG_LINES_TAB.SHIP_TO_PARTY_NAME(i) := NULL;
938: pty.party_number
939: INTO ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_NAME(i),
940: ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_NUMBER(i)
941: FROM hz_parties pty,
942: zx_party_tax_profile ptp
943: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_TAX_PROF_ID(i)
944: AND ptp.party_id = pty.party_id;
945: EXCEPTION WHEN OTHERS THEN
946: ZX_PTNR_NEG_LINES_TAB.BILL_FROM_PARTY_NAME(i) := NULL;
975: pty.party_number
976: INTO ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_NAME(i),
977: ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_NUMBER(i)
978: FROM hz_parties pty,
979: zx_party_tax_profile ptp
980: WHERE ptp.party_tax_profile_id = ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_TAX_PROF_ID(i)
981: AND ptp.party_id = pty.party_id;
982: EXCEPTION WHEN OTHERS THEN
983: ZX_PTNR_NEG_LINES_TAB.SHIP_FROM_PARTY_NAME(i) := NULL;
1021: BEGIN
1022: BEGIN
1023: SELECT ptp.party_tax_profile_id
1024: INTO x_party_tax_profile_id
1025: FROM hz_cust_site_uses_all siteuse, hz_cust_acct_sites_all site, hz_cust_accounts acct, zx_party_tax_profile ptp
1026: WHERE siteuse.site_use_id = p_site_use_id and
1027: siteuse.cust_acct_site_id = site.cust_acct_site_id and
1028: site.cust_account_id = acct.cust_account_id and
1029: acct.party_id = ptp.party_id and
2286: Begin
2287: SELECT pty.party_name
2288: INTO l_srvc_prvdr_name
2289: FROM HZ_PARTIES pty,
2290: ZX_PARTY_TAX_PROFILE ptp
2291: WHERE ptp.party_tax_profile_id =p_srvc_prvdr_id
2292: AND pty.party_id = ptp.party_id
2293: AND ptp.provider_type_code in ('BOTH', 'SERVICE');
2294: Exception
2620: Begin
2621: SELECT pty.party_name
2622: INTO l_srvc_prvdr_name
2623: FROM HZ_PARTIES pty,
2624: ZX_PARTY_TAX_PROFILE ptp
2625: WHERE ptp.party_tax_profile_id =p_srvc_prvdr_id
2626: AND pty.party_id = ptp.party_id
2627: AND ptp.provider_type_code in ('BOTH', 'SERVICE');
2628: Exception