DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PUB dependencies on PA_CI_IMPACTS

Line 80: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='WORKPLAN';

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;

Line 212: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='STAFFING';

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;

Line 340: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='CONTRACT';

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;

Line 465: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='OTHER';

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;

Line 593: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='SUPPLIER';

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;

Line 756: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='WORKPLAN';

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);

Line 757: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;

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;

Line 887: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='STAFFING';

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);

Line 888: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;

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;

Line 1021: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='CONTRACT';

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);

Line 1022: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;

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;

Line 1153: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='OTHER';

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);

Line 1154: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;

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;

Line 1284: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE:='SUPPLIER';

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);

Line 1285: l_ci_impact_id pa_ci_impacts.ci_impact_id%Type;

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;