76: x_impact_id OUT NOCOPY NUMBER
77: )
78: IS
79: --Declaring local Variables
80: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='WORKPLAN';
81: l_msg_count NUMBER := 0;
82: l_data VARCHAR2(2000);
83: l_msg_data VARCHAR2(2000);
84: l_msg_index_out NUMBER;
208: x_impact_id OUT NOCOPY NUMBER
209: )
210: IS
211: --Declaring local Variables
212: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='STAFFING';
213: l_msg_count NUMBER := 0;
214: l_data VARCHAR2(2000);
215: l_msg_data VARCHAR2(2000);
216: l_msg_index_out NUMBER;
336: x_impact_id OUT NOCOPY NUMBER
337: )
338: IS
339: --Declaring local Variables
340: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='CONTRACT';
341: l_msg_count NUMBER := 0;
342: l_data VARCHAR2(2000);
343: l_msg_data VARCHAR2(2000);
344: l_msg_index_out NUMBER;
461: x_impact_id OUT NOCOPY NUMBER
462: )
463: IS
464: --Declaring local Variables
465: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='OTHER';
466: l_msg_count NUMBER := 0;
467: l_data VARCHAR2(2000);
468: l_msg_data VARCHAR2(2000);
469: l_msg_index_out NUMBER;
589: x_impact_id OUT NOCOPY NUMBER
590: )
591: IS
592: --Declaring local Variables
593: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='SUPPLIER';
594: l_msg_count NUMBER := 0;
595: l_data VARCHAR2(2000);
596: l_msg_data VARCHAR2(2000);
597: l_msg_index_out NUMBER;
752: p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR
753: )
754: IS
755: --Declaring local Variables
756: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='WORKPLAN';
757: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;
758: l_msg_count NUMBER := 0;
759: l_data VARCHAR2(2000);
760: l_msg_data VARCHAR2(2000);
753: )
754: IS
755: --Declaring local Variables
756: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='WORKPLAN';
757: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;
758: l_msg_count NUMBER := 0;
759: l_data VARCHAR2(2000);
760: l_msg_data VARCHAR2(2000);
761: l_msg_index_out NUMBER;
883: p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR
884: )
885: IS
886: --Declaring local Variables
887: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='STAFFING';
888: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;
889: l_msg_count NUMBER := 0;
890: l_data VARCHAR2(2000);
891: l_msg_data VARCHAR2(2000);
884: )
885: IS
886: --Declaring local Variables
887: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='STAFFING';
888: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;
889: l_msg_count NUMBER := 0;
890: l_data VARCHAR2(2000);
891: l_msg_data VARCHAR2(2000);
892: l_msg_index_out NUMBER;
1017: p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR
1018: )
1019: IS
1020: --Declaring local Variables
1021: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='CONTRACT';
1022: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;
1023: l_msg_count NUMBER := 0;
1024: l_data VARCHAR2(2000);
1025: l_msg_data VARCHAR2(2000);
1018: )
1019: IS
1020: --Declaring local Variables
1021: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='CONTRACT';
1022: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;
1023: l_msg_count NUMBER := 0;
1024: l_data VARCHAR2(2000);
1025: l_msg_data VARCHAR2(2000);
1026: l_msg_index_out NUMBER;
1149: p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR
1150: )
1151: IS
1152: --Declaring local Variables
1153: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='OTHER';
1154: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;
1155: l_msg_count NUMBER := 0;
1156: l_data VARCHAR2(2000);
1157: l_msg_data VARCHAR2(2000);
1150: )
1151: IS
1152: --Declaring local Variables
1153: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='OTHER';
1154: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;
1155: l_msg_count NUMBER := 0;
1156: l_data VARCHAR2(2000);
1157: l_msg_data VARCHAR2(2000);
1158: l_msg_index_out NUMBER;
1280: p_impact_description IN VARCHAR2 := G_PA_MISS_CHAR
1281: )
1282: IS
1283: --Declaring local Variables
1284: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='SUPPLIER';
1285: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;
1286: l_msg_count NUMBER := 0;
1287: l_data VARCHAR2(2000);
1288: l_msg_data VARCHAR2(2000);
1281: )
1282: IS
1283: --Declaring local Variables
1284: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='SUPPLIER';
1285: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;
1286: l_msg_count NUMBER := 0;
1287: l_data VARCHAR2(2000);
1288: l_msg_data VARCHAR2(2000);
1289: l_msg_index_out NUMBER;