APPS.CSFW_TASKS_PUB dependencies on DUAL

Line 1016: x_individual_owner Number;

1012: l_organization_id NUMBER;
1013: l_org_id NUMBER;
1014: x_interaction_id Number;
1015: x_workflow_process_id Number;
1016: x_individual_owner Number;
1017: x_group_owner Number;
1018: x_individual_type Varchar2(200);
1019: x_object_version_number Number;
1020: x_reciprocal_link_id Number;

Line 1018: x_individual_type Varchar2(200);

1014: x_interaction_id Number;
1015: x_workflow_process_id Number;
1016: x_individual_owner Number;
1017: x_group_owner Number;
1018: x_individual_type Varchar2(200);
1019: x_object_version_number Number;
1020: x_reciprocal_link_id Number;
1021: x_link_id Number;
1022: x_pm_conf_reqd Varchar2(1);

Line 1104: SELECT CS_HZ_SR_CONTACT_POINTS_S.NEXTVAL FROM DUAL;

1100: CURSOR c_party_type( v_contact_id number) IS
1101: SELECT party_type FROM hz_parties WHERE party_id = v_contact_id;
1102:
1103: CURSOR c_contact_points_next IS
1104: SELECT CS_HZ_SR_CONTACT_POINTS_S.NEXTVAL FROM DUAL;
1105:
1106: cursor c_from_ib_instance(v_instance_id number) is
1107: SELECT
1108: LOCATION_ID,

Line 1403: x_individual_owner => x_individual_owner,

1399: x_request_id => x_new_incident_id,
1400: x_request_number => x_incident_number,
1401: x_interaction_id => x_interaction_id,
1402: x_workflow_process_id => x_workflow_process_id,
1403: x_individual_owner => x_individual_owner,
1404: x_group_owner => x_group_owner,
1405: x_individual_type => x_individual_type );
1406:
1407:

Line 1405: x_individual_type => x_individual_type );

1401: x_interaction_id => x_interaction_id,
1402: x_workflow_process_id => x_workflow_process_id,
1403: x_individual_owner => x_individual_owner,
1404: x_group_owner => x_group_owner,
1405: x_individual_type => x_individual_type );
1406:
1407:
1408: -- open the file
1409: /*