APPS.PV_PG_INVITE_HEADERS_PVT dependencies on PV_PG_INVITE_HEADERS_B

Line 12: -- with three new columns in pv_pg_invite_headers_b: partner_id,

8: --
9: -- History
10: -- 08/26/03 ktsao Update the Create_Invite_Headers, Update_Invite_Headers,
11: -- check_Invite_Headers_Req_Items, and Complete_Invite_Headers_Rec
12: -- with three new columns in pv_pg_invite_headers_b: partner_id,
13: -- INVITE_END_DATE , and ORDER_HEADER_ID.
14: -- NOTE
15: --
16: -- This Api is generated with Latest version of

Line 100: SELECT pv_pg_invite_headers_b_s.NEXTVAL

96: l_org_id NUMBER := FND_API.G_MISS_NUM;
97: l_INVITE_HEADER_ID NUMBER;
98: l_dummy NUMBER;
99: CURSOR c_id IS
100: SELECT pv_pg_invite_headers_b_s.NEXTVAL
101: FROM dual;
102:
103: CURSOR c_id_exists (l_id IN NUMBER) IS
104: SELECT 1

Line 105: FROM PV_PG_INVITE_HEADERS_B

101: FROM dual;
102:
103: CURSOR c_id_exists (l_id IN NUMBER) IS
104: SELECT 1
105: FROM PV_PG_INVITE_HEADERS_B
106: WHERE INVITE_HEADER_ID = l_id;
107: BEGIN
108: -- Standard Start of API savepoint
109: SAVEPOINT create_invite_headers_pvt;

Line 347: FROM PV_PG_INVITE_HEADERS_B

343:
344:
345: CURSOR c_get_invite_headers(invite_header_id NUMBER) IS
346: SELECT *
347: FROM PV_PG_INVITE_HEADERS_B
348: WHERE invite_header_id = p_invite_headers_rec.invite_header_id;
349: -- Hint: Developer need to provide Where clause
350:
351:

Line 864: 'pv_pg_invite_headers_b',

860: IF p_validation_mode = JTF_PLSQL_API.g_create
861: AND p_invite_headers_rec.INVITE_HEADER_ID IS NOT NULL
862: THEN
863: l_valid_flag := PVX_UTility_PVT.check_uniqueness(
864: 'pv_pg_invite_headers_b',
865: 'INVITE_HEADER_ID = ''' || p_invite_headers_rec.INVITE_HEADER_ID ||''''
866: );
867: END IF;
868:

Line 1034: FROM pv_pg_invite_headers_b

1030: l_return_status VARCHAR2(1);
1031:
1032: CURSOR c_complete IS
1033: SELECT *
1034: FROM pv_pg_invite_headers_b
1035: WHERE INVITE_HEADER_ID = p_invite_headers_rec.INVITE_HEADER_ID;
1036: l_invite_headers_rec c_complete%ROWTYPE;
1037: BEGIN
1038: x_complete_rec := p_invite_headers_rec;