eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_GA_ORG_ASSIGN_PVT dependencies on PO_GA_ORG_ASSIGNMENTS

Line 18: -- PO_GA_ORG_ASSIGNMENTS.

14: --Name: insert_row
15: --Pre-reqs:
16: -- None.
17: --Modifies:
18: -- PO_GA_ORG_ASSIGNMENTS.
19: -- FND_MSG_PUB on error.
20: --Locks:
21: -- None.
22: --Function:

Line 23: -- Inserts the record p_org_assign_rec into PO_GA_ORG_ASSIGNMENTS. Shows

19: -- FND_MSG_PUB on error.
20: --Locks:
21: -- None.
22: --Function:
23: -- Inserts the record p_org_assign_rec into PO_GA_ORG_ASSIGNMENTS. Shows
24: -- message PO_GA_ORG_ASSIGN_DUPLICATE on error.
25: --Parameters:
26: --IN:
27: --p_init_msg_list

Line 30: -- Record of the entire row of PO_GA_ORG_ASSIGNMENTS table.

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
33: -- FND_API.g_ret_sts_success - on success
34: -- FND_API.g_ret_sts_error - if duplicate row is inserted

Line 44: p_org_assign_rec IN PO_GA_ORG_ASSIGNMENTS%ROWTYPE,

40: --------------------------------------------------------------------------------
41: PROCEDURE insert_row
42: ( p_init_msg_list IN VARCHAR2, --< Shared Proc FPJ >
43: x_return_status OUT NOCOPY VARCHAR2, --< Shared Proc FPJ >
44: p_org_assign_rec IN PO_GA_ORG_ASSIGNMENTS%ROWTYPE,
45: x_row_id OUT NOCOPY ROWID
46: )
47: IS
48: l_org_assignment_id PO_GA_ORG_ASSIGNMENTS.ORG_ASSIGNMENT_ID%TYPE; --

Line 48: l_org_assignment_id PO_GA_ORG_ASSIGNMENTS.ORG_ASSIGNMENT_ID%TYPE; --

44: p_org_assign_rec IN PO_GA_ORG_ASSIGNMENTS%ROWTYPE,
45: x_row_id OUT NOCOPY ROWID
46: )
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

Line 61: -- SQL Why: to insert into po_ga_org_assignments

57: --< Shared Proc FPJ End >
58:
59: --
60: -- SQL What:retrieve the value of org_assignment_id
61: -- SQL Why: to insert into po_ga_org_assignments
62: SELECT PO_GA_ORG_ASSIGNMENTS_S.nextval
63: INTO l_org_assignment_id
64: FROM dual;
65: --

Line 62: SELECT PO_GA_ORG_ASSIGNMENTS_S.nextval

58:
59: --
60: -- SQL What:retrieve the value of org_assignment_id
61: -- SQL Why: to insert into po_ga_org_assignments
62: SELECT PO_GA_ORG_ASSIGNMENTS_S.nextval
63: INTO l_org_assignment_id
64: FROM dual;
65: --
66:

Line 67: INSERT INTO po_ga_org_assignments

63: INTO l_org_assignment_id
64: FROM dual;
65: --
66:
67: INSERT INTO po_ga_org_assignments
68: ( org_assignment_id , --
69: po_header_id ,
70: organization_id ,
71: enabled_flag ,

Line 117: -- PO_GA_ORG_ASSIGNMENTS

113: --Name: update_row
114: --Pre-reqs:
115: -- None.
116: --Modifies:
117: -- PO_GA_ORG_ASSIGNMENTS
118: -- FND_MSG_PUB on error.
119: --Locks:
120: -- PO_GA_ORG_ASSIGNMENTS
121: --Function:

Line 120: -- PO_GA_ORG_ASSIGNMENTS

116: --Modifies:
117: -- PO_GA_ORG_ASSIGNMENTS
118: -- FND_MSG_PUB on error.
119: --Locks:
120: -- PO_GA_ORG_ASSIGNMENTS
121: --Function:
122: -- Updates the PO_GA_ORG_ASSIGNMENTS row with rowid p_row_id. Only the
123: -- following columns are updated:
124: -- organization_id

Line 122: -- Updates the PO_GA_ORG_ASSIGNMENTS row with rowid p_row_id. Only the

118: -- FND_MSG_PUB on error.
119: --Locks:
120: -- PO_GA_ORG_ASSIGNMENTS
121: --Function:
122: -- Updates the PO_GA_ORG_ASSIGNMENTS row with rowid p_row_id. Only the
123: -- following columns are updated:
124: -- organization_id
125: -- purchasing_org_id
126: -- enabled_flag

Line 137: -- Record of the entire row of PO_GA_ORG_ASSIGNMENTS table.

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:
140: --x_return_status
141: -- FND_API.g_ret_sts_success - on success

Line 150: p_org_assign_rec IN PO_GA_ORG_ASSIGNMENTS%ROWTYPE,

146: --------------------------------------------------------------------------------
147: PROCEDURE update_row
148: ( p_init_msg_list IN VARCHAR2,
149: x_return_status OUT NOCOPY VARCHAR2,
150: p_org_assign_rec IN PO_GA_ORG_ASSIGNMENTS%ROWTYPE,
151: p_row_id IN ROWID
152: )
153: IS
154:

Line 163: UPDATE po_ga_org_assignments

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,
166: enabled_flag = p_org_assign_rec.enabled_flag,
167: vendor_site_id = p_org_assign_rec.vendor_site_id,

Line 190: DESCRIPTION: Deletes a row from PO_GA_ORG_ASSIGNMENTS.

186: /*==============================================================================
187:
188: PROCEDURE: delete_row
189:
190: DESCRIPTION: Deletes a row from PO_GA_ORG_ASSIGNMENTS.
191:
192: ==============================================================================*/
193: PROCEDURE delete_row
194: (

Line 195: p_po_header_id IN PO_GA_ORG_ASSIGNMENTS.po_header_id%TYPE

191:
192: ==============================================================================*/
193: PROCEDURE delete_row
194: (
195: p_po_header_id IN PO_GA_ORG_ASSIGNMENTS.po_header_id%TYPE
196: )
197: IS
198: BEGIN
199:

Line 200: DELETE FROM po_ga_org_assignments

196: )
197: IS
198: BEGIN
199:
200: DELETE FROM po_ga_org_assignments
201: WHERE po_header_id = p_po_header_id;
202:
203: EXCEPTION
204:

Line 219: -- PO_GA_ORG_ASSIGNMENTS.

215: --Name: delete_row
216: --Pre-reqs:
217: -- None.
218: --Modifies:
219: -- PO_GA_ORG_ASSIGNMENTS.
220: --Locks:
221: -- PO_GA_ORG_ASSIGNMENTS
222: --Function:
223: -- Deletes the row in PO_GA_ORG_ASSIGNMENTS with p_po_header_id and

Line 221: -- PO_GA_ORG_ASSIGNMENTS

217: -- None.
218: --Modifies:
219: -- PO_GA_ORG_ASSIGNMENTS.
220: --Locks:
221: -- PO_GA_ORG_ASSIGNMENTS
222: --Function:
223: -- Deletes the row in PO_GA_ORG_ASSIGNMENTS with p_po_header_id and
224: -- p_organization_id. Uses APP_EXCEPTION.raise_exception when error occurs.
225: --Parameters:

Line 223: -- Deletes the row in PO_GA_ORG_ASSIGNMENTS with p_po_header_id and

219: -- PO_GA_ORG_ASSIGNMENTS.
220: --Locks:
221: -- PO_GA_ORG_ASSIGNMENTS
222: --Function:
223: -- Deletes the row in PO_GA_ORG_ASSIGNMENTS with p_po_header_id and
224: -- p_organization_id. Uses APP_EXCEPTION.raise_exception when error occurs.
225: --Parameters:
226: --IN:
227: --p_po_header_id

Line 239: DELETE FROM po_ga_org_assignments

235: )
236: IS
237: BEGIN
238:
239: DELETE FROM po_ga_org_assignments
240: WHERE po_header_id = p_po_header_id
241: AND organization_id = p_organization_id;
242:
243: EXCEPTION

Line 261: -- PO_GA_ORG_ASSIGNMENTS

257: -- None.
258: --Modifies:
259: -- None.
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:

Line 263: -- Locks the row in PO_GA_ORG_ASSIGNMENTS with rowid p_row_id. If the DB lock

259: -- None.
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

Line 281: ( p_org_assign_rec IN PO_GA_ORG_ASSIGNMENTS%ROWTYPE,

277: --p_row_id
278: --End of Comments
279: --------------------------------------------------------------------------------
280: PROCEDURE lock_row
281: ( p_org_assign_rec IN PO_GA_ORG_ASSIGNMENTS%ROWTYPE,
282: p_row_id IN ROWID
283: )
284: IS
285: l_pgoa_rec PO_GA_ORG_ASSIGNMENTS%ROWTYPE;

Line 285: l_pgoa_rec PO_GA_ORG_ASSIGNMENTS%ROWTYPE;

281: ( p_org_assign_rec IN PO_GA_ORG_ASSIGNMENTS%ROWTYPE,
282: p_row_id IN ROWID
283: )
284: IS
285: l_pgoa_rec PO_GA_ORG_ASSIGNMENTS%ROWTYPE;
286: BEGIN
287:
288: --SQL What: Lock the record with rowid p_row_id.
289: --SQL Why: Obtain the lock and compare values to see if there's a difference

Line 292: FROM po_ga_org_assignments

288: --SQL What: Lock the record with rowid p_row_id.
289: --SQL Why: Obtain the lock and compare values to see if there's a difference
290: SELECT *
291: INTO l_pgoa_rec
292: FROM po_ga_org_assignments
293: WHERE rowid = p_row_id
294: FOR UPDATE NOWAIT;
295:
296: IF (l_pgoa_rec.organization_id <> p_org_assign_rec.organization_id) OR

Line 332: -- PO_GA_ORG_ASSIGNMENTS

328: --Name: copy_rows
329: --Pre-reqs:
330: -- None.
331: --Modifies:
332: -- PO_GA_ORG_ASSIGNMENTS
333: -- FND_MSG_PUB on error.
334: --Locks:
335: -- None.
336: --Function:

Line 384: -- Used PO_GA_ORG_ASSIGNMENTS_S.nextval directly inside insert statement

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: --
386:
387: INSERT INTO PO_GA_ORG_ASSIGNMENTS
388: (

Line 387: INSERT INTO PO_GA_ORG_ASSIGNMENTS

383: --
384: -- Used PO_GA_ORG_ASSIGNMENTS_S.nextval directly inside insert statement
385: --
386:
387: INSERT INTO PO_GA_ORG_ASSIGNMENTS
388: (
389: org_assignment_id, --
390: po_header_id,
391: organization_id,

Line 401: SELECT PO_GA_ORG_ASSIGNMENTS_S.nextval ,--Bug#4623941

397: created_by,
398: last_update_login,
399: purchasing_org_id
400: )
401: SELECT PO_GA_ORG_ASSIGNMENTS_S.nextval ,--Bug#4623941
402: p_to_po_header_id,
403: pgoa.organization_id,
404: pgoa.enabled_flag,
405: pgoa.vendor_site_id,

Line 412: FROM po_ga_org_assignments pgoa

408: p_creation_date,
409: p_created_by,
410: p_last_update_login,
411: pgoa.purchasing_org_id
412: FROM po_ga_org_assignments pgoa
413: WHERE pgoa.po_header_id = p_from_po_header_id;
414:
415: IF (SQL%ROWCOUNT = 0) THEN
416: -- Return error if nothing was inserted