[Home] [Help]
99: --
100: -- HISTORY
101: -- 07-JUN-94 S Lee Added status and stage
102: -- 29-MAR-94 S Lee Modified for using new database schema and
103: -- application standards
104: -- 18-NOV-93 S Lee Revamped
105: -- 28-SEP-93 S Lee Created
106: --
107:
133: l_start_date DATE;
134: l_end_date DATE;
135: l_org_override NUMBER(15) DEFAULT 0; /*2933915*/
136:
137: -- Standard who
138: x_last_updated_by NUMBER(15);
139: x_created_by NUMBER(15);
140: x_last_update_login NUMBER(15);
141: x_request_id NUMBER(15);
187: status := 0;
188: stage := 100;
189:
190: --
191: -- Get the standard who information
192: --
193: x_created_by := FND_GLOBAL.USER_ID;
194: x_last_updated_by := FND_GLOBAL.USER_ID;
195: x_last_update_login := FND_GLOBAL.LOGIN_ID;
197: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
198: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
199:
200:
201: -- Get the standard who information
202: --
203: -- Compile the indirect cost rates for this organization.
204: -- First check if there is an override on this organization.
205: -- If so, compile rates for this organization, and create a new set.
925: WHERE cmp.organization_id = p_org_id
926: AND cmp.ind_rate_sch_revision_id = p_rev_id
927: AND status = 'A';
928:
929: -- Standard who
930: x_last_updated_by NUMBER(15);
931: x_last_update_login NUMBER(15);
932: x_request_id NUMBER(15);
933: x_program_application_id NUMBER(15);
967: This is to generate compiled multipliers for the new organization in all the burden
968: schedule revisions (even when nothing has changed in the revisions
969: i.e ready_to_compile_flag is <>'Y'/'X')*/
970: --
971: -- Get the standard who information
972: --
973: x_last_updated_by := FND_GLOBAL.USER_ID;
974: x_last_update_login := FND_GLOBAL.LOGIN_ID;
975: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1216: org_tab org_tab_type; /*2933915*/ /*To store top impacted orgs*/
1217: lstatus number ; /*2933915*/
1218: l_check number ; /*3055700*/
1219: l_cp_structure pa_cost_plus_structures.cost_plus_structure%TYPE ; /*3055700*/
1220: -- Standard who
1221: x_last_updated_by NUMBER(15);
1222: x_last_update_login NUMBER(15);
1223: x_request_id NUMBER(15);
1224: x_program_application_id NUMBER(15);
1239: status := 0;
1240: rate_sch_rev_id := sch_rev_id;
1241: G_RATE_SCH_REVISION_ID := rate_sch_rev_id;
1242: --
1243: -- Get the standard who information
1244: --
1245: x_last_updated_by := FND_GLOBAL.USER_ID;
1246: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1247: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3450: --
3451: -- 08-JUN-94 S Lee Changed the input parameter
3452: -- 18-APR-94 S Lee Added error handler
3453: -- 29-MAR-94 S Lee Modified for the new database schema and
3454: -- application standard
3455: -- 20-NOV-93 S Lee Created
3456: --
3457:
3458: procedure get_cost_base (exp_type IN varchar2,
3930: cbicc_id number;
3931: structure_type varchar2(30);
3932: icc_precedence number;
3933:
3934: -- Standard who
3935: x_last_updated_by NUMBER(15);
3936: x_created_by NUMBER(15);
3937: x_last_update_login NUMBER(15);
3938:
3942: stage := 100;
3943: status := 0;
3944:
3945: --
3946: -- Standard who
3947: --
3948:
3949: x_created_by := FND_GLOBAL.USER_ID;
3950: x_last_updated_by := FND_GLOBAL.USER_ID;
4138: AND irsr.actual_sch_revision_id = rate_sch_rev_id;
4139:
4140:
4141:
4142: -- Standard who
4143: x_last_updated_by NUMBER(15);
4144: x_last_update_login NUMBER(15);
4145: x_request_id NUMBER(15);
4146: x_program_application_id NUMBER(15);
4156:
4157: gl_mc_currency_pkg.G_PA_UPGRADE_MODE := TRUE; /*Bug 4527736 */
4158:
4159: --
4160: -- Get the standard who information
4161: --
4162: x_last_updated_by := FND_GLOBAL.USER_ID;
4163: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4164: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5182: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5183:
5184:
5185:
5186: -- Standard who
5187: x_last_updated_by NUMBER(15);
5188: x_last_update_login NUMBER(15);
5189: x_request_id NUMBER(15);
5190: x_program_application_id NUMBER(15);
5194:
5195: BEGIN
5196:
5197: --
5198: -- Get the standard who information
5199: --
5200: x_last_updated_by := FND_GLOBAL.USER_ID;
5201: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5202: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6384: -- Local variable
6385: ei_count number;
6386: adj_module constant varchar2(10) := 'PACOCRSR';
6387:
6388: -- Standard who
6389: x_request_id NUMBER(15);
6390:
6391: -- Exception
6392: INSERT_ADJ_ACTIVITY_ERROR exception;
6458: AND cbet.expenditure_type = ITEM.expenditure_type
6459: )
6460: ;*/
6461:
6462: -- Standard who
6463: x_last_updated_by NUMBER(15);
6464: x_last_update_login NUMBER(15);
6465: x_program_application_id NUMBER(15);
6466: x_program_id NUMBER(15);
6473: status := 0;
6474: stage := 100;
6475:
6476: --
6477: -- Get the standard who information
6478: --
6479: x_last_updated_by := FND_GLOBAL.USER_ID;
6480: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6481: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6783: AND org_structure_version_id = ver_id
6784: UNION
6785: select org_id from dual ;
6786:
6787: -- Standard who
6788: x_last_updated_by NUMBER(15);
6789: x_last_update_login NUMBER(15);
6790: x_request_id NUMBER(15);
6791: x_program_application_id NUMBER(15);
6793: org_override NUMBER :=0;
6794: BEGIN
6795:
6796: --
6797: -- Get the standard who information
6798: --
6799: x_last_updated_by := FND_GLOBAL.USER_ID;
6800: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6801: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6860: stage IN OUT NOCOPY number)
6861:
6862: is
6863:
6864: -- Standard who
6865: x_last_updated_by NUMBER(15);
6866: x_last_update_login NUMBER(15);
6867: x_request_id NUMBER(15);
6868: x_program_application_id NUMBER(15);
6870:
6871: BEGIN
6872:
6873: --
6874: -- Get the standard who information
6875: --
6876: x_last_updated_by := FND_GLOBAL.USER_ID;
6877: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6878: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;