APPS.CSFW_TASKS_PUB dependencies on DUAL

Line 999: x_individual_owner Number;

995: l_primary_contact VARCHAR2(1);
996: l_organization_id NUMBER;
997: x_interaction_id Number;
998: x_workflow_process_id Number;
999: x_individual_owner Number;
1000: x_group_owner Number;
1001: x_individual_type Varchar2(200);
1002: x_object_version_number Number;
1003: x_reciprocal_link_id Number;

Line 1001: x_individual_type Varchar2(200);

997: x_interaction_id Number;
998: x_workflow_process_id Number;
999: x_individual_owner Number;
1000: x_group_owner Number;
1001: x_individual_type Varchar2(200);
1002: x_object_version_number Number;
1003: x_reciprocal_link_id Number;
1004: x_link_id Number;
1005: x_pm_conf_reqd Varchar2(1);

Line 1087: SELECT CS_HZ_SR_CONTACT_POINTS_S.NEXTVAL FROM DUAL;

1083: CURSOR c_party_type( v_contact_id number) IS
1084: SELECT party_type FROM hz_parties WHERE party_id = v_contact_id;
1085:
1086: CURSOR c_contact_points_next IS
1087: SELECT CS_HZ_SR_CONTACT_POINTS_S.NEXTVAL FROM DUAL;
1088:
1089: cursor c_from_ib_instance(v_instance_id number) is
1090: SELECT
1091: LOCATION_ID,

Line 1385: x_individual_owner => x_individual_owner,

1381: x_request_id => x_new_incident_id,
1382: x_request_number => x_incident_number,
1383: x_interaction_id => x_interaction_id,
1384: x_workflow_process_id => x_workflow_process_id,
1385: x_individual_owner => x_individual_owner,
1386: x_group_owner => x_group_owner,
1387: x_individual_type => x_individual_type );
1388:
1389:

Line 1387: x_individual_type => x_individual_type );

1383: x_interaction_id => x_interaction_id,
1384: x_workflow_process_id => x_workflow_process_id,
1385: x_individual_owner => x_individual_owner,
1386: x_group_owner => x_group_owner,
1387: x_individual_type => x_individual_type );
1388:
1389:
1390: -- open the file
1391: /*