APPS.IGW_PROP dependencies on IGW_PROP_CHECKLIST

Line 990: INSERT INTO igw_prop_checklist

986: BEGIN
987:
988: /*
989:
990: INSERT INTO igw_prop_checklist
991: (
992: proposal_id,
993: document_type_code,
994: checklist_order,

Line 1017: igw_prop_checklist

1013: SYSDATE,
1014: FND_GLOBAL.USER_ID,
1015: FND_GLOBAL.LOGIN_ID
1016: FROM
1017: igw_prop_checklist
1018: WHERE
1019: proposal_id = p_old_proposal_id;
1020:
1021: */

Line 1023: Igw_Prop_Checklist_Pvt.Populate_Checklist

1019: proposal_id = p_old_proposal_id;
1020:
1021: */
1022:
1023: Igw_Prop_Checklist_Pvt.Populate_Checklist
1024: (
1025: p_proposal_id => p_new_proposal_id,
1026: x_return_status => l_return_status
1027: );

Line 1168: update igw_prop_checklist

1164: i_value IN varchar2 ) IS
1165: BEGIN
1166:
1167: IF i_component_name = 'BUDGET' THEN
1168: update igw_prop_checklist
1169: set complete = decode(i_value,'C','Y','N'),
1170: not_applicable = decode(i_value,'N','Y','N'),
1171: last_update_date = sysdate,
1172: last_updated_by = fnd_global.user_id,

Line 1179: update igw_prop_checklist

1175: and document_type_code = 'BUDGETS';
1176:
1177: ELSIF i_component_name = 'NARRATIVE' THEN
1178:
1179: update igw_prop_checklist
1180: set complete = decode(i_value,'C','Y','N'),
1181: not_applicable = decode(i_value,'N','Y','N'),
1182: last_update_date = sysdate,
1183: last_updated_by = fnd_global.user_id,