[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;
3480: --
3481: -- 08-JUN-94 S Lee Changed the input parameter
3482: -- 18-APR-94 S Lee Added error handler
3483: -- 29-MAR-94 S Lee Modified for the new database schema and
3484: -- application standard
3485: -- 20-NOV-93 S Lee Created
3486: --
3487:
3488: procedure get_cost_base (exp_type IN varchar2,
3960: cbicc_id number;
3961: structure_type varchar2(30);
3962: icc_precedence number;
3963:
3964: -- Standard who
3965: x_last_updated_by NUMBER(15);
3966: x_created_by NUMBER(15);
3967: x_last_update_login NUMBER(15);
3968:
3972: stage := 100;
3973: status := 0;
3974:
3975: --
3976: -- Standard who
3977: --
3978:
3979: x_created_by := FND_GLOBAL.USER_ID;
3980: x_last_updated_by := FND_GLOBAL.USER_ID;
4168: AND irsr.actual_sch_revision_id = rate_sch_rev_id;
4169:
4170:
4171:
4172: -- Standard who
4173: x_last_updated_by NUMBER(15);
4174: x_last_update_login NUMBER(15);
4175: x_request_id NUMBER(15);
4176: x_program_application_id NUMBER(15);
4186:
4187: gl_mc_currency_pkg.G_PA_UPGRADE_MODE := TRUE; /*Bug 4527736 */
4188:
4189: --
4190: -- Get the standard who information
4191: --
4192: x_last_updated_by := FND_GLOBAL.USER_ID;
4193: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4194: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5212: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5213:
5214:
5215:
5216: -- Standard who
5217: x_last_updated_by NUMBER(15);
5218: x_last_update_login NUMBER(15);
5219: x_request_id NUMBER(15);
5220: x_program_application_id NUMBER(15);
5224:
5225: BEGIN
5226:
5227: --
5228: -- Get the standard who information
5229: --
5230: x_last_updated_by := FND_GLOBAL.USER_ID;
5231: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5232: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6611: -- Local variable
6612: ei_count number;
6613: adj_module constant varchar2(10) := 'PACOCRSR';
6614:
6615: -- Standard who
6616: x_request_id NUMBER(15);
6617:
6618: -- Exception
6619: INSERT_ADJ_ACTIVITY_ERROR exception;
6685: AND cbet.expenditure_type = ITEM.expenditure_type
6686: )
6687: ;*/
6688:
6689: -- Standard who
6690: x_last_updated_by NUMBER(15);
6691: x_last_update_login NUMBER(15);
6692: x_program_application_id NUMBER(15);
6693: x_program_id NUMBER(15);
6700: status := 0;
6701: stage := 100;
6702:
6703: --
6704: -- Get the standard who information
6705: --
6706: x_last_updated_by := FND_GLOBAL.USER_ID;
6707: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6708: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7010: AND org_structure_version_id = ver_id
7011: UNION
7012: select org_id from dual ;
7013:
7014: -- Standard who
7015: x_last_updated_by NUMBER(15);
7016: x_last_update_login NUMBER(15);
7017: x_request_id NUMBER(15);
7018: x_program_application_id NUMBER(15);
7020: org_override NUMBER :=0;
7021: BEGIN
7022:
7023: --
7024: -- Get the standard who information
7025: --
7026: x_last_updated_by := FND_GLOBAL.USER_ID;
7027: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7028: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7087: stage IN OUT NOCOPY number)
7088:
7089: is
7090:
7091: -- Standard who
7092: x_last_updated_by NUMBER(15);
7093: x_last_update_login NUMBER(15);
7094: x_request_id NUMBER(15);
7095: x_program_application_id NUMBER(15);
7097:
7098: BEGIN
7099:
7100: --
7101: -- Get the standard who information
7102: --
7103: x_last_updated_by := FND_GLOBAL.USER_ID;
7104: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7105: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;