APPS.OTA_OM_UPD_API dependencies on OTA_CUSTOMER_CONTACTS_V

Line 1056: l_control_contact_address_id ota_customer_contacts_v.address_id%TYPE := NULL;

1052: l_delegate_contact_email HZ_PARTIES.email_address%TYPE; ---changed
1053: l_contact_address_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE := NULL; --changed
1054: l_correspondent varchar2(1) := 'C';
1055: l_student_address_id varchar2(1) := NULL;
1056: l_control_contact_address_id ota_customer_contacts_v.address_id%TYPE := NULL;
1057: l_control_student_address_id ota_customer_contacts_v.address_id%TYPE := NULL;
1058: l_stud_cont number := NULL;
1059: l_customer_id number;
1060: l_third_party_id number;

Line 1057: l_control_student_address_id ota_customer_contacts_v.address_id%TYPE := NULL;

1053: l_contact_address_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE := NULL; --changed
1054: l_correspondent varchar2(1) := 'C';
1055: l_student_address_id varchar2(1) := NULL;
1056: l_control_contact_address_id ota_customer_contacts_v.address_id%TYPE := NULL;
1057: l_control_student_address_id ota_customer_contacts_v.address_id%TYPE := NULL;
1058: l_stud_cont number := NULL;
1059: l_customer_id number;
1060: l_third_party_id number;
1061: l_contact_id number;

Line 1074: l_control_third_address_id ota_customer_contacts_v.address_id%TYPE := NULL;

1070: l_third_contact_phone varchar2(80);
1071: l_third_contact_fax varchar2(80);
1072: l_third_contact_email HZ_PARTIES.email_address%TYPE; --changed
1073: l_third_address_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE := NULL; --changed
1074: l_control_third_address_id ota_customer_contacts_v.address_id%TYPE := NULL;
1075: l_third_contact_id number;
1076:
1077:
1078:

Line 1130: from ota_customer_contacts_v

1126: and acct_role.cust_account_role_id = l_stud_cont;
1127: --
1128: Cursor get_control_contact_address_id IS
1129: select address_id
1130: from ota_customer_contacts_v
1131: where contact_id = P_SOLD_TO_CONTACT_ID
1132: and status = 'A'
1133: and (l_contact_address_id is not null
1134: and l_correspondent = 'C'

Line 1137: from ota_customer_contacts_v cus

1133: and (l_contact_address_id is not null
1134: and l_correspondent = 'C'
1135: and address_id = l_contact_address_id
1136: or not exists (select null
1137: from ota_customer_contacts_v cus
1138: where cus.contact_id = P_SOLD_TO_CONTACT_ID
1139: and cus.address_id =l_contact_address_id)
1140: or l_contact_address_id is null
1141: or l_correspondent <> 'C' );

Line 1146: from ota_customer_contacts_v

1142:
1143: -- ***
1144: Cursor get_control_student_address_id IS
1145: select address_id
1146: from ota_customer_contacts_v
1147: where contact_id = P_SHIP_TO_CONTACT_ID
1148: and status = 'A'
1149: and (l_contact_address_id is not null
1150: and l_correspondent = 'S'

Line 1153: from ota_customer_contacts_v cus

1149: and (l_contact_address_id is not null
1150: and l_correspondent = 'S'
1151: and address_id = l_contact_address_id
1152: or not exists (select null
1153: from ota_customer_contacts_v cus
1154: where cus.contact_id = P_SHIP_TO_CONTACT_ID
1155: and cus.address_id = l_contact_address_id)
1156: or l_contact_address_id is null
1157: or l_correspondent <> 'S' );

Line 1207: from ota_customer_contacts_v

1203:
1204: -- For Third Party --
1205: Cursor get_control_third_address_id IS
1206: select address_id
1207: from ota_customer_contacts_v
1208: where contact_id = P_SOLD_TO_CONTACT_ID
1209: and status = 'A';
1210:
1211: