DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_SITE_BO_PUB dependencies on HZ_CUST_ACCOUNT_SITE_V2PUB

Line 38: px_cust_acct_site_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE

34: p_cust_acct_site_id IN NUMBER,
35: p_cust_acct_site_os IN VARCHAR2,
36: p_cust_acct_site_osr IN VARCHAR2,
37: p_create_or_update IN VARCHAR2 := 'C',
38: px_cust_acct_site_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE
39: );
40:
41: -- PRIVATE PROCEDURE assign_cust_acct_site_rec
42: --

Line 75: px_cust_acct_site_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE

71: p_cust_acct_site_id IN NUMBER,
72: p_cust_acct_site_os IN VARCHAR2,
73: p_cust_acct_site_osr IN VARCHAR2,
74: p_create_or_update IN VARCHAR2 := 'C',
75: px_cust_acct_site_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE
76: ) IS
77: BEGIN
78: px_cust_acct_site_rec.cust_acct_site_id := p_cust_acct_site_id;
79: px_cust_acct_site_rec.party_site_id := p_party_site_id;

Line 165: l_cust_acct_site_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;

161: px_parent_acct_os IN OUT NOCOPY VARCHAR2,
162: px_parent_acct_osr IN OUT NOCOPY VARCHAR2
163: ) IS
164: l_debug_prefix VARCHAR2(30) := '';
165: l_cust_acct_site_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;
166:
167: l_ps_id NUMBER;
168: l_ps_os VARCHAR2(30);
169: l_ps_osr VARCHAR2(255);

Line 313: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site (

309: p_cust_acct_site_osr => x_cust_acct_site_osr,
310: px_cust_acct_site_rec => l_cust_acct_site_rec
311: );
312:
313: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site (
314: p_cust_acct_site_rec => l_cust_acct_site_rec,
315: x_cust_acct_site_id => x_cust_acct_site_id,
316: x_return_status => x_return_status,
317: x_msg_count => x_msg_count,

Line 664: l_cust_acct_site_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;

660: x_cust_acct_site_osr OUT NOCOPY VARCHAR2,
661: p_parent_os IN VARCHAR2
662: )IS
663: l_debug_prefix VARCHAR2(30) := '';
664: l_cust_acct_site_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;
665: l_cas_ovn NUMBER;
666: l_create_update_flag VARCHAR2(1);
667: l_parent_os VARCHAR2(30);
668: l_party_site_id NUMBER;

Line 745: HZ_CUST_ACCOUNT_SITE_V2PUB.update_cust_acct_site(

741: p_create_or_update => 'U',
742: px_cust_acct_site_rec => l_cust_acct_site_rec
743: );
744:
745: HZ_CUST_ACCOUNT_SITE_V2PUB.update_cust_acct_site(
746: p_cust_acct_site_rec => l_cust_acct_site_rec,
747: p_object_version_number => l_cas_ovn,
748: x_return_status => x_return_status,
749: x_msg_count => x_msg_count,

Line 1475: px_cust_acct_site_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE

1471: p_cust_acct_site_id IN NUMBER,
1472: p_cust_acct_site_os IN VARCHAR2,
1473: p_cust_acct_site_osr IN VARCHAR2,
1474: p_create_or_update IN VARCHAR2 := 'C',
1475: px_cust_acct_site_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE
1476: );
1477:
1478: -- PRIVATE PROCEDURE assign_cust_acct_site_v2_rec
1479: --

Line 1512: px_cust_acct_site_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE

1508: p_cust_acct_site_id IN NUMBER,
1509: p_cust_acct_site_os IN VARCHAR2,
1510: p_cust_acct_site_osr IN VARCHAR2,
1511: p_create_or_update IN VARCHAR2 := 'C',
1512: px_cust_acct_site_rec IN OUT NOCOPY HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE
1513: ) IS
1514: BEGIN
1515: px_cust_acct_site_rec.cust_acct_site_id := p_cust_acct_site_id;
1516: px_cust_acct_site_rec.party_site_id := p_party_site_id;

Line 1602: l_cust_acct_site_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;

1598: px_parent_acct_os IN OUT NOCOPY VARCHAR2,
1599: px_parent_acct_osr IN OUT NOCOPY VARCHAR2
1600: ) IS
1601: l_debug_prefix VARCHAR2(30) := '';
1602: l_cust_acct_site_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;
1603:
1604: l_ps_id NUMBER;
1605: l_ps_os VARCHAR2(30);
1606: l_ps_osr VARCHAR2(255);

Line 1750: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site (

1746: p_cust_acct_site_osr => x_cust_acct_site_osr,
1747: px_cust_acct_site_rec => l_cust_acct_site_rec
1748: );
1749:
1750: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site (
1751: p_cust_acct_site_rec => l_cust_acct_site_rec,
1752: x_cust_acct_site_id => x_cust_acct_site_id,
1753: x_return_status => x_return_status,
1754: x_msg_count => x_msg_count,

Line 1994: l_cust_acct_site_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;

1990: x_cust_acct_site_osr OUT NOCOPY VARCHAR2,
1991: p_parent_os IN VARCHAR2
1992: )IS
1993: l_debug_prefix VARCHAR2(30) := '';
1994: l_cust_acct_site_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE;
1995: l_cas_ovn NUMBER;
1996: l_create_update_flag VARCHAR2(1);
1997: l_parent_os VARCHAR2(30);
1998: l_party_site_id NUMBER;

Line 2075: HZ_CUST_ACCOUNT_SITE_V2PUB.update_cust_acct_site(

2071: p_create_or_update => 'U',
2072: px_cust_acct_site_rec => l_cust_acct_site_rec
2073: );
2074:
2075: HZ_CUST_ACCOUNT_SITE_V2PUB.update_cust_acct_site(
2076: p_cust_acct_site_rec => l_cust_acct_site_rec,
2077: p_object_version_number => l_cas_ovn,
2078: x_return_status => x_return_status,
2079: x_msg_count => x_msg_count,