APPS.PSB_POSITION_PAY_DISTR_PVT dependencies on PSB_POSITION_PAY_DISTRIBUTIONS

Line 28: description psb_position_pay_distributions.description%TYPE,

24: award_id NUMBER,
25: expenditure_type VARCHAR2(30),
26: expenditure_organization_id NUMBER,
27: --UTF8 changes for Bug No : 2615261
28: description psb_position_pay_distributions.description%TYPE,
29: delete_flag VARCHAR2(1));
30:
31: TYPE g_paydist_tbl_type IS TABLE OF g_paydist_rec_type
32: INDEX BY BINARY_INTEGER;

Line 128: cursor C is select ROWID from PSB_POSITION_PAY_DISTRIBUTIONS

124: p_expenditure_organization_id IN NUMBER:= FND_API.G_MISS_NUM,
125: p_description IN VARCHAR2:= FND_API.G_MISS_CHAR,
126: p_mode in varchar2 := 'R'
127: ) is
128: cursor C is select ROWID from PSB_POSITION_PAY_DISTRIBUTIONS
129: where distribution_id = P_distribution_id;
130: P_LAST_UPDATE_DATE DATE;
131: P_LAST_UPDATED_BY NUMBER;
132: P_LAST_UPDATE_LOGIN NUMBER;

Line 166: insert into PSB_POSITION_PAY_DISTRIBUTIONS(

162: FND_MSG_PUB.Add ;
163: raise FND_API.G_EXC_ERROR;
164: end if;
165: --
166: insert into PSB_POSITION_PAY_DISTRIBUTIONS(
167: distribution_id ,
168: position_id ,
169: data_extract_id ,
170: worksheet_id ,

Line 310: from PSB_POSITION_PAY_DISTRIBUTIONS

306: award_id,
307: expenditure_type,
308: expenditure_organization_id,
309: description
310: from PSB_POSITION_PAY_DISTRIBUTIONS
311: where distribution_id = P_distribution_id
312: for update of distribution_id nowait;
313: tlinfo c1%rowtype;
314: --

Line 506: update PSB_POSITION_PAY_DISTRIBUTIONS set

502: end if;
503:
504: -- do the update of the record
505: --
506: update PSB_POSITION_PAY_DISTRIBUTIONS set
507: code_combination_id = p_code_combination_id,
508: effective_start_date = decode(p_effective_start_date, FND_API.G_MISS_DATE, effective_start_date, p_effective_start_date),
509: effective_end_date = decode(p_effective_end_date, FND_API.G_MISS_DATE, effective_end_date, p_effective_end_date),
510: distribution_percent = p_distribution_percent,

Line 616: cursor c1 is select rowid from PSB_POSITION_PAY_DISTRIBUTIONS

612: p_mode in varchar2 := 'R'
613:
614:
615: ) is
616: cursor c1 is select rowid from PSB_POSITION_PAY_DISTRIBUTIONS
617: where position_id = p_position_id
618: ;
619: dummy c1%rowtype;
620: --

Line 744: delete from PSB_POSITION_PAY_DISTRIBUTIONS

740: --
741: p_return_status := FND_API.G_RET_STS_SUCCESS ;
742:
743: --
744: delete from PSB_POSITION_PAY_DISTRIBUTIONS
745: where distribution_id = p_distribution_id;
746: if (sql%notfound) THEN
747: null;
748: end if;

Line 829: delete from PSB_POSITION_PAY_DISTRIBUTIONS

825: if FND_API.to_Boolean (p_init_msg_list) then
826: FND_MSG_PUB.initialize;
827: end if;
828:
829: delete from PSB_POSITION_PAY_DISTRIBUTIONS
830: where data_extract_id = p_data_extract_id;
831:
832:
833: -- Standard check of p_commit

Line 924: DELETE from PSB_POSITION_PAY_DISTRIBUTIONS

920: if FND_API.to_Boolean (p_init_msg_list) then
921: FND_MSG_PUB.initialize;
922: end if;
923:
924: DELETE from PSB_POSITION_PAY_DISTRIBUTIONS
925: WHERE position_id = p_position_id
926: /* Bug 4545909 Start */
927: AND ((worksheet_id IS NULL AND p_worksheet_id IS NULL)
928: OR worksheet_id = p_worksheet_id);

Line 1454: from PSB_POSITION_PAY_DISTRIBUTIONS

1450: award_id,
1451: expenditure_type,
1452: expenditure_organization_id,
1453: description
1454: from PSB_POSITION_PAY_DISTRIBUTIONS
1455: where (worksheet_id is null or worksheet_id = p_worksheet_id)
1456: and chart_of_accounts_id = p_chart_of_accounts_id
1457: and code_combination_id = p_code_combination_id
1458: and (((p_effective_end_date is not null)

Line 1495: update PSB_POSITION_PAY_DISTRIBUTIONS

1491:
1492: l_userid := FND_GLOBAL.USER_ID;
1493: l_loginid := FND_GLOBAL.LOGIN_ID;
1494:
1495: update PSB_POSITION_PAY_DISTRIBUTIONS
1496: set distribution_percent = decode(p_distribution_percent, null, distribution_percent, p_distribution_percent),
1497: global_default_flag = decode(p_global_default_flag, null, global_default_flag, p_global_default_flag),
1498: distribution_default_rule_id = decode(p_distribution_default_rule_id, null, distribution_default_rule_id, p_distribution_default_rule_id),
1499: project_id = decode(p_project_id, null, project_id, FND_API.G_MISS_NUM, project_id, p_project_id),

Line 2195: from PSB_POSITION_PAY_DISTRIBUTIONS

2191: from dual;
2192:
2193: cursor c_overlap is
2194: select distribution_id
2195: from PSB_POSITION_PAY_DISTRIBUTIONS
2196: where chart_of_accounts_id = p_chart_of_accounts_id
2197: and worksheet_id = p_worksheet_id
2198: and code_combination_id = p_code_combination_id
2199: and (((p_effective_end_date is not null)

Line 2305: from psb_position_pay_distributions

2301: chart_of_accounts_id,
2302: global_default_flag,
2303: distribution_default_rule_id,
2304: rowid
2305: from psb_position_pay_distributions
2306: where position_id = p_position_id
2307: and worksheet_id is null;
2308:
2309: cursor c_Seq is

Line 2659: FROM PSB_POSITION_PAY_DISTRIBUTIONS

2655: award_id,
2656: expenditure_type,
2657: expenditure_organization_id,
2658: description
2659: FROM PSB_POSITION_PAY_DISTRIBUTIONS
2660: WHERE
2661: /* Bug 4545909 Start */
2662: ((worksheet_id IS NULL AND NOT EXISTS (
2663: SELECT 1 FROM psb_position_pay_distributions

Line 2663: SELECT 1 FROM psb_position_pay_distributions

2659: FROM PSB_POSITION_PAY_DISTRIBUTIONS
2660: WHERE
2661: /* Bug 4545909 Start */
2662: ((worksheet_id IS NULL AND NOT EXISTS (
2663: SELECT 1 FROM psb_position_pay_distributions
2664: WHERE worksheet_id = p_worksheet_id
2665: AND position_id = p_position_id))
2666: OR worksheet_id = p_worksheet_id
2667: OR (worksheet_id IS NULL AND p_worksheet_id IS NULL))

Line 2686: FROM PSB_POSITION_PAY_DISTRIBUTIONS

2682: /* Bug 4545909 Start */
2683: l_de_exists BOOLEAN := FALSE;
2684: CURSOR l_exists IS
2685: SELECT 1
2686: FROM PSB_POSITION_PAY_DISTRIBUTIONS
2687: WHERE data_extract_id = p_data_extract_id
2688: AND position_id = p_position_id and worksheet_id IS NULL;
2689: /* Bug 4545909 End */
2690: