DBA Data[Home] [Help]

APPS.PO_GA_ORG_ASSIGN_PVT dependencies on STANDARD

Line 28: -- Standard API parameter to initialize the API message list.

24: -- message PO_GA_ORG_ASSIGN_DUPLICATE on error.
25: --Parameters:
26: --IN:
27: --p_init_msg_list
28: -- Standard API parameter to initialize the API message list.
29: --p_org_assign_rec
30: -- Record of the entire row of PO_GA_ORG_ASSIGNMENTS table.
31: --OUT:
32: --x_return_status

Line 51: -- Start standard API initialization

47: IS
48: l_org_assignment_id PO_GA_ORG_ASSIGNMENTS.ORG_ASSIGNMENT_ID%TYPE; --
49: BEGIN
50: --< Shared Proc FPJ Start >
51: -- Start standard API initialization
52: IF FND_API.to_boolean(p_init_msg_list) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55: x_return_status := FND_API.g_ret_sts_success;

Line 56: -- End standard API initialization

52: IF FND_API.to_boolean(p_init_msg_list) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55: x_return_status := FND_API.g_ret_sts_success;
56: -- End standard API initialization
57: --< Shared Proc FPJ End >
58:
59: --
60: -- SQL What:retrieve the value of org_assignment_id

Line 135: -- Standard API parameter to initialize the API message list.

131: -- Shows message PO_GA_ORG_ASSIGN_DUPLICATE on duplicate rows error.
132: --Parameters:
133: --IN:
134: --p_init_msg_list
135: -- Standard API parameter to initialize the API message list.
136: --p_org_assign_rec
137: -- Record of the entire row of PO_GA_ORG_ASSIGNMENTS table.
138: --p_row_id
139: --OUT:

Line 156: -- Start standard API initialization

152: )
153: IS
154:
155: BEGIN
156: -- Start standard API initialization
157: IF FND_API.to_boolean(p_init_msg_list) THEN
158: FND_MSG_PUB.initialize;
159: END IF;
160: x_return_status := FND_API.g_ret_sts_success;

Line 161: -- End standard API initialization

157: IF FND_API.to_boolean(p_init_msg_list) THEN
158: FND_MSG_PUB.initialize;
159: END IF;
160: x_return_status := FND_API.g_ret_sts_success;
161: -- End standard API initialization
162:
163: UPDATE po_ga_org_assignments
164: SET organization_id = p_org_assign_rec.organization_id,
165: purchasing_org_id = p_org_assign_rec.purchasing_org_id,

Line 264: -- cannot be acquired, then standard FND record lock exception handling is

260: --Locks:
261: -- PO_GA_ORG_ASSIGNMENTS
262: --Function:
263: -- Locks the row in PO_GA_ORG_ASSIGNMENTS with rowid p_row_id. If the DB lock
264: -- cannot be acquired, then standard FND record lock exception handling is
265: -- used. The following columns are compared with the database values:
266: -- organization_id
267: -- purchasing_org_id
268: -- vendor_site_id

Line 343: -- Standard param initializes API message list if FND_API.g_true;

339: -- with the input parameters.
340: --Parameters:
341: --IN:
342: --p_init_msg_list
343: -- Standard param initializes API message list if FND_API.g_true;
344: --p_from_po_header_id
345: -- The header ID of the original GA whose org assignments will be copied.
346: --p_to_po_header_id
347: -- The header ID of the new GA for the new org assignments.

Line 376: -- Start standard API initialization

372: p_last_update_login IN NUMBER
373: )
374: IS
375: BEGIN
376: -- Start standard API initialization
377: IF FND_API.to_boolean(p_init_msg_list) THEN
378: FND_MSG_PUB.initialize;
379: END IF;
380: x_return_status := FND_API.g_ret_sts_success;

Line 381: -- End standard API initialization

377: IF FND_API.to_boolean(p_init_msg_list) THEN
378: FND_MSG_PUB.initialize;
379: END IF;
380: x_return_status := FND_API.g_ret_sts_success;
381: -- End standard API initialization
382:
383: --
384: -- Used PO_GA_ORG_ASSIGNMENTS_S.nextval directly inside insert statement
385: --