APPS.CSM_PARTY_DOWNLOAD_PUB dependencies on CSM_PARTY_SITES_ACC

Line 17: l_party_site_id csm_party_sites_acc.party_site_id%TYPE := NULL;

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);
21: l_sqlerrmsg VARCHAR2(3000);

Line 170: l_party_site_id csm_party_sites_acc.party_site_id%TYPE := NULL;

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);
174: l_sqlerrmsg VARCHAR2(3000);

Line 507: l_location_id csm_party_sites_acc.party_site_id%TYPE;

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;
510: l_return_status VARCHAR2(3000);
511: l_error_message VARCHAR2(3000);

Line 509: l_party_site_id csm_party_sites_acc.party_site_id%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);
513: l_sqlerrmsg VARCHAR2(3000) := NULL;