eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on FND_GLOBAL

Line 447: last_updated_by = FND_GLOBAL.USER_ID,

443: freeze_flag = decode(p_freeze_flag, FND_API.G_MISS_CHAR, freeze_flag, p_freeze_flag),
444: request_id = decode(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
445: base_line_revision = decode(p_base_line_revision, FND_API.G_MISS_CHAR, base_line_revision, p_base_line_revision),
446: last_update_date = sysdate,
447: last_updated_by = FND_GLOBAL.USER_ID,
448: last_update_login = FND_GLOBAL.LOGIN_ID,
449: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
450: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
451: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),

Line 448: last_update_login = FND_GLOBAL.LOGIN_ID,

444: request_id = decode(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),
445: base_line_revision = decode(p_base_line_revision, FND_API.G_MISS_CHAR, base_line_revision, p_base_line_revision),
446: last_update_date = sysdate,
447: last_updated_by = FND_GLOBAL.USER_ID,
448: last_update_login = FND_GLOBAL.LOGIN_ID,
449: attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
450: attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
451: attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
452: attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),

Line 571: decode(p_requestor,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, -1, FND_GLOBAL.USER_ID, p_requestor),

567: decode(p_transaction_type,FND_API.G_MISS_CHAR,null,p_transaction_type),
568: decode(p_permanent_revision,FND_API.G_MISS_CHAR,null,p_permanent_revision),
569: decode(p_revise_by_position,FND_API.G_MISS_CHAR,null,p_revise_by_position),
570: decode(p_balance_type,FND_API.G_MISS_CHAR,'YTD',p_balance_type),
571: decode(p_requestor,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, -1, FND_GLOBAL.USER_ID, p_requestor),
572: decode(p_parameter_set_id,FND_API.G_MISS_NUM,null,p_parameter_set_id),
573: decode(p_constraint_set_id,FND_API.G_MISS_NUM,null,p_constraint_set_id),
574: decode(p_submission_date,FND_API.G_MISS_DATE,null,p_submission_date),
575: decode(p_submission_status,FND_API.G_MISS_CHAR,null,p_submission_status),

Line 584: FND_GLOBAL.USER_ID,

580: decode(p_base_line_revision,FND_API.G_MISS_CHAR,null,p_base_line_revision),
581: decode(p_global_budget_revision,FND_API.G_MISS_CHAR,null,p_global_budget_revision),
582: decode(p_global_budget_revision_id,FND_API.G_MISS_NUM,null,p_global_budget_revision_id),
583: sysdate,
584: FND_GLOBAL.USER_ID,
585: FND_GLOBAL.LOGIN_ID,
586: FND_GLOBAL.USER_ID,
587: sysdate,
588: decode(p_attribute1,FND_API.G_MISS_CHAR,null,p_attribute1),

Line 585: FND_GLOBAL.LOGIN_ID,

581: decode(p_global_budget_revision,FND_API.G_MISS_CHAR,null,p_global_budget_revision),
582: decode(p_global_budget_revision_id,FND_API.G_MISS_NUM,null,p_global_budget_revision_id),
583: sysdate,
584: FND_GLOBAL.USER_ID,
585: FND_GLOBAL.LOGIN_ID,
586: FND_GLOBAL.USER_ID,
587: sysdate,
588: decode(p_attribute1,FND_API.G_MISS_CHAR,null,p_attribute1),
589: decode(p_attribute2,FND_API.G_MISS_CHAR,null,p_attribute2),

Line 586: FND_GLOBAL.USER_ID,

582: decode(p_global_budget_revision_id,FND_API.G_MISS_NUM,null,p_global_budget_revision_id),
583: sysdate,
584: FND_GLOBAL.USER_ID,
585: FND_GLOBAL.LOGIN_ID,
586: FND_GLOBAL.USER_ID,
587: sysdate,
588: decode(p_attribute1,FND_API.G_MISS_CHAR,null,p_attribute1),
589: decode(p_attribute2,FND_API.G_MISS_CHAR,null,p_attribute2),
590: decode(p_attribute3,FND_API.G_MISS_CHAR,null,p_attribute3),

Line 1127: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)

1123: decode(p_revision_value_type, 'A', Get_Rounded_Amount(p_currency_code, p_revision_amount), p_revision_amount), p_functional_transaction,
1124: decode(p_funds_status_code, FND_API.G_MISS_CHAR, null, p_funds_status_code),
1125: decode(p_funds_result_code, FND_API.G_MISS_CHAR, null, p_funds_result_code),
1126: decode(p_note_id, FND_API.G_MISS_NUM, null, p_note_id), p_funds_control_timestamp,
1127: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)
1128: returning budget_revision_acct_line_id into l_budget_revision_acct_line_id;
1129:
1130: for c_Global_Rev_Rec in c_Global_Rev (p_budget_revision_id) loop
1131: l_global_revision_id := c_Global_Rev_Rec.global_revision_id;

Line 1143: p_view_line_flag, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID,

1139: (BUDGET_REVISION_ACCT_LINE_ID, BUDGET_REVISION_ID, FREEZE_FLAG,
1140: VIEW_LINE_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
1141: CREATION_DATE)
1142: VALUES (l_budget_revision_acct_line_id, c_Distribute_Rev_Rec.budget_revision_id, p_freeze_flag,
1143: p_view_line_flag, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID,
1144: sysdate);
1145:
1146: end loop;
1147:

Line 1166: last_updated_by = FND_GLOBAL.USER_ID,

1162: funds_control_timestamp = p_funds_control_timestamp,
1163: note_id = decode(p_note_id, FND_API.G_MISS_NUM, note_id, null, note_id, p_note_id),
1164: freeze_flag = p_freeze_flag,
1165: last_update_date = sysdate,
1166: last_updated_by = FND_GLOBAL.USER_ID,
1167: last_update_login = FND_GLOBAL.LOGIN_ID,
1168: currency_code = p_currency_code -- Bug 3029168
1169: where budget_revision_acct_line_id = l_budget_revision_acct_line_id;
1170:

Line 1167: last_update_login = FND_GLOBAL.LOGIN_ID,

1163: note_id = decode(p_note_id, FND_API.G_MISS_NUM, note_id, null, note_id, p_note_id),
1164: freeze_flag = p_freeze_flag,
1165: last_update_date = sysdate,
1166: last_updated_by = FND_GLOBAL.USER_ID,
1167: last_update_login = FND_GLOBAL.LOGIN_ID,
1168: currency_code = p_currency_code -- Bug 3029168
1169: where budget_revision_acct_line_id = l_budget_revision_acct_line_id;
1170:
1171: end;

Line 1673: p_requestor => FND_GLOBAL.USER_ID,

1669: p_transaction_type => NULL,
1670: p_permanent_revision => 'Y',
1671: p_global_budget_revision => null,
1672: p_global_budget_revision_id => null,
1673: p_requestor => FND_GLOBAL.USER_ID,
1674: p_parameter_set_id => null,
1675: p_constraint_set_id => null,
1676: p_submission_date => null,
1677: p_submission_status => null,

Line 2035: FND_GLOBAL.USER_ID,

2031: p_quarter_num(l_indx),
2032: p_currency_code(l_indx),
2033: p_status_code(l_indx),
2034: SYSDATE,
2035: FND_GLOBAL.USER_ID,
2036: p_budget_version_id(l_indx),
2037: p_entered_dr(l_indx),
2038: p_entered_cr(l_indx),
2039: p_accounted_dr(l_indx),

Line 2237: if (fnd_global.conc_request_id <> -1) then

2233: l_packet_id := c_seq_rec.seq;
2234: end loop;
2235:
2236: -- Added IF statement for Bug:3681872
2237: if (fnd_global.conc_request_id <> -1) then
2238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Packet ID: ' || l_packet_id);
2239: end if;
2240:
2241: -- Bug#4310411 Start

Line 3741: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate);

3737: effective_end_date, revision_type, revision_value_type, revision_value, note_id,
3738: last_update_date, last_updated_by, last_update_login, created_by, creation_date)
3739: VALUES (l_budget_revision_pos_line_id, p_position_id, p_budget_group_id, p_effective_start_date,
3740: p_effective_end_date, p_revision_type, p_revision_value_type, p_revision_value, p_note_id,
3741: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate);
3742:
3743: for c_Global_Rev_Rec in c_Global_Rev (p_budget_revision_id) loop
3744: l_global_revision_id := c_Global_Rev_Rec.global_revision_id;
3745: end loop;

Line 3755: p_freeze_flag, p_view_line_flag, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,

3751: INSERT INTO PSB_BUDGET_REVISION_POS_LINES (budget_revision_pos_line_id, budget_revision_id,
3752: freeze_flag, view_line_flag, last_update_date, last_updated_by, last_update_login,
3753: created_by, creation_date)
3754: VALUES (l_budget_revision_pos_line_id, c_Distribute_Rev_Rec.budget_revision_id,
3755: p_freeze_flag, p_view_line_flag, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
3756: FND_GLOBAL.USER_ID, sysdate);
3757:
3758: end loop;
3759:

Line 3756: FND_GLOBAL.USER_ID, sysdate);

3752: freeze_flag, view_line_flag, last_update_date, last_updated_by, last_update_login,
3753: created_by, creation_date)
3754: VALUES (l_budget_revision_pos_line_id, c_Distribute_Rev_Rec.budget_revision_id,
3755: p_freeze_flag, p_view_line_flag, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
3756: FND_GLOBAL.USER_ID, sysdate);
3757:
3758: end loop;
3759:
3760: p_budget_revision_pos_line_id := l_budget_revision_pos_line_id;

Line 3804: last_updated_by = FND_GLOBAL.USER_ID,

3800: revision_value_type = p_revision_value_type,
3801: revision_value = p_revision_value,
3802: note_id = decode(p_note_id, null, note_id, p_note_id),
3803: last_update_date = sysdate,
3804: last_updated_by = FND_GLOBAL.USER_ID,
3805: last_update_login = FND_GLOBAL.LOGIN_ID
3806: WHERE budget_revision_pos_line_id = p_budget_revision_pos_line_id;
3807:
3808: -- Initialize API return status to success

Line 3805: last_update_login = FND_GLOBAL.LOGIN_ID

3801: revision_value = p_revision_value,
3802: note_id = decode(p_note_id, null, note_id, p_note_id),
3803: last_update_date = sysdate,
3804: last_updated_by = FND_GLOBAL.USER_ID,
3805: last_update_login = FND_GLOBAL.LOGIN_ID
3806: WHERE budget_revision_pos_line_id = p_budget_revision_pos_line_id;
3807:
3808: -- Initialize API return status to success
3809:

Line 3930: last_updated_by = FND_GLOBAL.USER_ID,

3926: revision_type = p_revision_type,
3927: revision_value_type = p_revision_value_type,
3928: revision_value = p_revision_value,
3929: last_update_date = sysdate,
3930: last_updated_by = FND_GLOBAL.USER_ID,
3931: last_update_login = FND_GLOBAL.LOGIN_ID
3932: where position_id = p_position_id
3933: and effective_start_date = p_effective_start_date
3934: and nvl(effective_end_date, FND_API.G_MISS_DATE) = nvl(p_effective_end_date, FND_API.G_MISS_DATE)

Line 3931: last_update_login = FND_GLOBAL.LOGIN_ID

3927: revision_value_type = p_revision_value_type,
3928: revision_value = p_revision_value,
3929: last_update_date = sysdate,
3930: last_updated_by = FND_GLOBAL.USER_ID,
3931: last_update_login = FND_GLOBAL.LOGIN_ID
3932: where position_id = p_position_id
3933: and effective_start_date = p_effective_start_date
3934: and nvl(effective_end_date, FND_API.G_MISS_DATE) = nvl(p_effective_end_date, FND_API.G_MISS_DATE)
3935: and exists

Line 7973: values (FND_GLOBAL.CONC_REQUEST_ID,

7969: Source_Process,
7970: Description,
7971: Creation_Date,
7972: Created_By)
7973: values (FND_GLOBAL.CONC_REQUEST_ID,
7974: p_budget_revision_id,
7975: 'BUDGET_REVISION',
7976: l_description,
7977: sysdate,

Line 7978: FND_GLOBAL.USER_ID);

7974: p_budget_revision_id,
7975: 'BUDGET_REVISION',
7976: l_description,
7977: sysdate,
7978: FND_GLOBAL.USER_ID);
7979:
7980: end;
7981: else
7982: p_constraint_validation_status := 'S';

Line 8479: values (FND_GLOBAL.CONC_REQUEST_ID,

8475: Source_Process,
8476: Description,
8477: Creation_Date,
8478: Created_By)
8479: values (FND_GLOBAL.CONC_REQUEST_ID,
8480: p_budget_revision_id,
8481: 'BUDGET_REVISION',
8482: l_description,
8483: sysdate,

Line 8484: FND_GLOBAL.USER_ID);

8480: p_budget_revision_id,
8481: 'BUDGET_REVISION',
8482: l_description,
8483: sysdate,
8484: FND_GLOBAL.USER_ID);
8485:
8486: if nvl(p_severity_level, -1) >= g_constraint_threshold then
8487: p_constraint_validation_status := 'F';
8488: else

Line 8563: values (FND_GLOBAL.CONC_REQUEST_ID,

8559: Source_Process,
8560: Description,
8561: Creation_Date,
8562: Created_By)
8563: values (FND_GLOBAL.CONC_REQUEST_ID,
8564: p_budget_revision_id,
8565: 'BUDGET_REVISION',
8566: l_description,
8567: sysdate,

Line 8568: FND_GLOBAL.USER_ID);

8564: p_budget_revision_id,
8565: 'BUDGET_REVISION',
8566: l_description,
8567: sysdate,
8568: FND_GLOBAL.USER_ID);
8569:
8570: if nvl(p_severity_level, -1) >= g_constraint_threshold then
8571: p_constraint_validation_status := 'F';
8572: else

Line 8686: values (FND_GLOBAL.CONC_REQUEST_ID,

8682: Source_Process,
8683: Description,
8684: Creation_Date,
8685: Created_By)
8686: values (FND_GLOBAL.CONC_REQUEST_ID,
8687: p_budget_revision_id,
8688: 'BUDGET_REVISION',
8689: l_description,
8690: sysdate,

Line 8691: FND_GLOBAL.USER_ID);

8687: p_budget_revision_id,
8688: 'BUDGET_REVISION',
8689: l_description,
8690: sysdate,
8691: FND_GLOBAL.USER_ID);
8692:
8693: end;
8694: else
8695: p_constraint_validation_status := 'S';

Line 8961: values (FND_GLOBAL.CONC_REQUEST_ID,

8957: Source_Process,
8958: Description,
8959: Creation_Date,
8960: Created_By)
8961: values (FND_GLOBAL.CONC_REQUEST_ID,
8962: p_budget_revision_id,
8963: 'BUDGET_REVISION',
8964: l_description,
8965: sysdate,

Line 8966: FND_GLOBAL.USER_ID);

8962: p_budget_revision_id,
8963: 'BUDGET_REVISION',
8964: l_description,
8965: sysdate,
8966: FND_GLOBAL.USER_ID);
8967:
8968: end;
8969: else
8970: p_constraint_validation_status := 'S';

Line 9338: last_updated_by = FND_GLOBAL.USER_ID,

9334: /* For Bug No.2810621 Start*/
9335: Update PSB_BUDGET_REVISIONS
9336: set constraint_set_id = g_constraint_set_id,
9337: last_update_date = sysdate,
9338: last_updated_by = FND_GLOBAL.USER_ID,
9339: last_update_login = FND_GLOBAL.LOGIN_ID
9340: where budget_revision_id = p_budget_revision_id;
9341: /* For Bug No. 2810621 End*/
9342:

Line 9339: last_update_login = FND_GLOBAL.LOGIN_ID

9335: Update PSB_BUDGET_REVISIONS
9336: set constraint_set_id = g_constraint_set_id,
9337: last_update_date = sysdate,
9338: last_updated_by = FND_GLOBAL.USER_ID,
9339: last_update_login = FND_GLOBAL.LOGIN_ID
9340: where budget_revision_id = p_budget_revision_id;
9341: /* For Bug No. 2810621 End*/
9342:
9343:

Line 11044: l_apply_message := l_apply_message||fnd_global.local_chr(10)||l_con_segments;

11040: SELECT concatenated_segments INTO l_con_segments
11041: FROM GL_CODE_COMBINATIONS_KFV
11042: WHERE code_combination_id = g_ccid_rec(l_index).ccid;
11043: IF (NVL(g_ccid_rec(l_index).apply_balance_flag,'A') = 'A') THEN
11044: l_apply_message := l_apply_message||fnd_global.local_chr(10)||l_con_segments;
11045: ELSIF (g_ccid_rec(l_index).apply_balance_flag = 'B') THEN
11046: l_balance_message := l_balance_message||fnd_global.local_chr(10)||l_con_segments;
11047: END IF;
11048: END LOOP;

Line 11046: l_balance_message := l_balance_message||fnd_global.local_chr(10)||l_con_segments;

11042: WHERE code_combination_id = g_ccid_rec(l_index).ccid;
11043: IF (NVL(g_ccid_rec(l_index).apply_balance_flag,'A') = 'A') THEN
11044: l_apply_message := l_apply_message||fnd_global.local_chr(10)||l_con_segments;
11045: ELSIF (g_ccid_rec(l_index).apply_balance_flag = 'B') THEN
11046: l_balance_message := l_balance_message||fnd_global.local_chr(10)||l_con_segments;
11047: END IF;
11048: END LOOP;
11049:
11050: l_description := l_description||l_apply_message;

Line 11056: l_description := l_description||fnd_global.local_chr(10)||l_apply_message||l_balance_message;

11052: add_message('PSB', 'PSB_REV_RULE_BALANCE_ACCTS');
11053: l_apply_message := FND_MSG_PUB.Get
11054: (p_encoded => FND_API.G_FALSE);
11055: FND_MSG_PUB.Delete_Msg;
11056: l_description := l_description||fnd_global.local_chr(10)||l_apply_message||l_balance_message;
11057: END IF;
11058: /*For Bug No : 2150471 End*/
11059:
11060:

Line 11068: values (FND_GLOBAL.CONC_REQUEST_ID,

11064: Source_Process,
11065: Description,
11066: Creation_Date,
11067: Created_By)
11068: values (FND_GLOBAL.CONC_REQUEST_ID,
11069: p_budget_revision_id,
11070: 'BUDGET_REVISION',
11071: l_description,
11072: sysdate,

Line 11073: FND_GLOBAL.USER_ID);

11069: p_budget_revision_id,
11070: 'BUDGET_REVISION',
11071: l_description,
11072: sysdate,
11073: FND_GLOBAL.USER_ID);
11074: /*For Bug No : 2125969 Start*/
11075: --END IF;
11076: /*For Bug No : 2125969 Start*/
11077: End IF;

Line 11767: values (psb_ws_account_line_notes_s.nextval, p_note, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)

11763: begin
11764:
11765: Insert into PSB_WS_ACCOUNT_LINE_NOTES
11766: (note_id, note, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
11767: values (psb_ws_account_line_notes_s.nextval, p_note, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)
11768: returning note_id into l_note_id;
11769:
11770: if p_account_line_id is not null then
11771: update PSB_BUDGET_REVISION_ACCOUNTS

Line 11785: SET note = note || FND_GLOBAL.NewLine || p_note,

11781: else
11782: -- Bug#4571412
11783: BEGIN
11784: Update PSB_WS_ACCOUNT_LINE_NOTES
11785: SET note = note || FND_GLOBAL.NewLine || p_note,
11786: last_update_date = sysdate,
11787: last_updated_by = FND_GLOBAL.USER_ID,
11788: last_update_login = FND_GLOBAL.LOGIN_ID,
11789: created_by = FND_GLOBAL.USER_ID,

Line 11787: last_updated_by = FND_GLOBAL.USER_ID,

11783: BEGIN
11784: Update PSB_WS_ACCOUNT_LINE_NOTES
11785: SET note = note || FND_GLOBAL.NewLine || p_note,
11786: last_update_date = sysdate,
11787: last_updated_by = FND_GLOBAL.USER_ID,
11788: last_update_login = FND_GLOBAL.LOGIN_ID,
11789: created_by = FND_GLOBAL.USER_ID,
11790: creation_date = sysdate
11791: WHERE note_id = l_note_id;

Line 11788: last_update_login = FND_GLOBAL.LOGIN_ID,

11784: Update PSB_WS_ACCOUNT_LINE_NOTES
11785: SET note = note || FND_GLOBAL.NewLine || p_note,
11786: last_update_date = sysdate,
11787: last_updated_by = FND_GLOBAL.USER_ID,
11788: last_update_login = FND_GLOBAL.LOGIN_ID,
11789: created_by = FND_GLOBAL.USER_ID,
11790: creation_date = sysdate
11791: WHERE note_id = l_note_id;
11792: EXCEPTION

Line 11789: created_by = FND_GLOBAL.USER_ID,

11785: SET note = note || FND_GLOBAL.NewLine || p_note,
11786: last_update_date = sysdate,
11787: last_updated_by = FND_GLOBAL.USER_ID,
11788: last_update_login = FND_GLOBAL.LOGIN_ID,
11789: created_by = FND_GLOBAL.USER_ID,
11790: creation_date = sysdate
11791: WHERE note_id = l_note_id;
11792: EXCEPTION
11793: WHEN others THEN