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.CSM_PARTY_DOWNLOAD_PUB dependencies on ASG_USER

Line 16: l_owner_id asg_user.owner_id%TYPE := NULL;

12: x_error_message OUT NOCOPY VARCHAR2
13: )
14: IS
15:
16: l_owner_id asg_user.owner_id%TYPE := NULL;
17: l_party_site_id csm_party_sites_acc.party_site_id%TYPE := NULL;
18: l_return_status VARCHAR2(3000);
19: l_error_message VARCHAR2(3000) := NULL;
20: l_msg_data VARCHAR2(3000);

Line 27: FROM asg_user au

23:
24: CURSOR csr_owner_id(p_user_id IN NUMBER)
25: IS
26: SELECT au.owner_id
27: FROM asg_user au
28: WHERE au.user_id = p_user_id
29: AND au.enabled = 'Y';
30:
31: BEGIN

Line 167: l_user_id asg_user.user_id%TYPE;

163: IS
164:
165: l_user_id_tbl l_user_id_tbl_type;
166: l_party_id_tbl l_party_id_tbl_type;
167: l_user_id asg_user.user_id%TYPE;
168: l_party_id csm_parties_acc.party_id%TYPE;
169: l_owner_id asg_user.owner_id%TYPE := NULL;
170: l_party_site_id csm_party_sites_acc.party_site_id%TYPE := NULL;
171: l_return_status VARCHAR2(3000);

Line 169: l_owner_id asg_user.owner_id%TYPE := NULL;

165: l_user_id_tbl l_user_id_tbl_type;
166: l_party_id_tbl l_party_id_tbl_type;
167: l_user_id asg_user.user_id%TYPE;
168: l_party_id csm_parties_acc.party_id%TYPE;
169: l_owner_id asg_user.owner_id%TYPE := NULL;
170: l_party_site_id csm_party_sites_acc.party_site_id%TYPE := NULL;
171: l_return_status VARCHAR2(3000);
172: l_error_message VARCHAR2(3000) := NULL;
173: l_msg_data VARCHAR2(3000);

Line 180: FROM asg_user au

176:
177: CURSOR csr_owner_id (p_user_id IN NUMBER)
178: IS
179: SELECT au.owner_id
180: FROM asg_user au
181: WHERE au.user_id = p_user_id
182: AND au.enabled = 'Y';
183:
184: BEGIN

Line 353: l_owner_id asg_user.owner_id%TYPE := NULL;

349: x_error_message OUT NOCOPY VARCHAR2
350: )
351: IS
352:
353: l_owner_id asg_user.owner_id%TYPE := NULL;
354: l_return_status VARCHAR2(3000);
355: l_error_message VARCHAR2(3000);
356: l_msg_data VARCHAR2(3000);
357: l_sqlerrmsg VARCHAR2(3000) := NULL;

Line 363: FROM asg_user au

359:
360: CURSOR csr_owner_id(p_user_id IN NUMBER)
361: IS
362: SELECT au.owner_id
363: FROM asg_user au
364: WHERE au.user_id = p_user_id
365: AND au.enabled = 'Y';
366:
367: BEGIN

Line 505: l_user_id asg_user.user_id%TYPE;

501: IS
502:
503: l_user_id_tbl l_user_id_tbl_type;
504: l_party_site_id_tbl l_party_id_tbl_type;
505: l_user_id asg_user.user_id%TYPE;
506: l_party_id csm_parties_acc.party_id%TYPE;
507: l_location_id csm_party_sites_acc.party_site_id%TYPE;
508: l_owner_id asg_user.owner_id%TYPE := NULL;
509: l_party_site_id csm_party_sites_acc.party_site_id%TYPE;

Line 508: l_owner_id asg_user.owner_id%TYPE := NULL;

504: l_party_site_id_tbl l_party_id_tbl_type;
505: l_user_id asg_user.user_id%TYPE;
506: l_party_id csm_parties_acc.party_id%TYPE;
507: l_location_id csm_party_sites_acc.party_site_id%TYPE;
508: l_owner_id asg_user.owner_id%TYPE := NULL;
509: l_party_site_id csm_party_sites_acc.party_site_id%TYPE;
510: l_return_status VARCHAR2(3000);
511: l_error_message VARCHAR2(3000);
512: l_msg_data VARCHAR2(3000);

Line 519: FROM asg_user au

515:
516: CURSOR csr_owner_id (p_user_id IN NUMBER)
517: IS
518: SELECT au.owner_id
519: FROM asg_user au
520: WHERE au.user_id = p_user_id
521: AND au.enabled = 'Y';
522:
523: BEGIN

Line 695: l_user_id asg_user.user_id%TYPE;

691:
692: IS
693:
694: l_party_id_tbl l_party_id_tbl_type;
695: l_user_id asg_user.user_id%TYPE;
696: l_msg_data VARCHAR2(3000);
697: l_sqlerrmsg VARCHAR2(3000);
698: l_sqlerrno VARCHAR2(20);
699: l_error_message VARCHAR2(3000);

Line 812: l_user_id asg_user.user_id%TYPE;

808:
809: IS
810:
811: l_party_site_id_tbl l_party_id_tbl_type;
812: l_user_id asg_user.user_id%TYPE;
813: l_party_id csm_parties_acc.party_id%TYPE;
814: l_msg_data VARCHAR2(3000);
815: l_sqlerrmsg VARCHAR2(3000);
816: l_sqlerrno VARCHAR2(20);