APPS.PAY_COST_ALLOCATIONS_F_PKG dependencies on PAY_COST_ALLOCATIONS_F

Line 1: package body PAY_COST_ALLOCATIONS_F_PKG as

1: package body PAY_COST_ALLOCATIONS_F_PKG as
2: /* $Header: pycsa01t.pkb 120.1 2005/10/04 05:27:56 pgongada noship $ */
3: --
4: procedure insert_row(p_rowid in out nocopy varchar2,
5: p_cost_allocation_id in number,

Line 19: insert into PAY_COST_ALLOCATIONS_F

15: p_program_update_date in date) IS
16: --
17: begin
18: --
19: insert into PAY_COST_ALLOCATIONS_F
20: ( COST_ALLOCATION_ID,
21: EFFECTIVE_START_DATE,
22: EFFECTIVE_END_DATE,
23: BUSINESS_GROUP_ID,

Line 46: from PAY_COST_ALLOCATIONS_F

42: p_program_update_date);
43: --
44: select rowid
45: into p_rowid
46: from PAY_COST_ALLOCATIONS_F
47: where COST_ALLOCATION_ID = p_cost_allocation_id
48: and EFFECTIVE_START_DATE = p_effective_start_date
49: and EFFECTIVE_END_DATE = p_effective_end_date;
50: --

Line 67: update PAY_COST_ALLOCATIONS_F

63: p_program_id in number,
64: p_program_update_date in date) is
65: begin
66: --
67: update PAY_COST_ALLOCATIONS_F
68: set COST_ALLOCATION_ID = p_cost_allocation_id,
69: EFFECTIVE_START_DATE = p_effective_start_date,
70: EFFECTIVE_END_DATE = p_effective_end_date,
71: BUSINESS_GROUP_ID = p_business_group_id,

Line 87: delete from PAY_COST_ALLOCATIONS_F

83: procedure delete_row(p_rowid in varchar2) is
84: --
85: begin
86: --
87: delete from PAY_COST_ALLOCATIONS_F
88: where ROWID = p_rowid;
89: --
90: end delete_row;
91: --

Line 106: from PAY_COST_ALLOCATIONS_F

102: p_program_id in number,
103: p_program_update_date in date) is
104: --
105: cursor C is select *
106: from PAY_COST_ALLOCATIONS_F
107: where rowid = p_rowid
108: for update of COST_ALLOCATION_ID nowait;
109: --
110: rowinfo C%rowtype;

Line 237: end PAY_COST_ALLOCATIONS_F_PKG;

233: p_segment29,
234: p_segment30);
235: --
236: end maintain_cost_keyflex;
237: end PAY_COST_ALLOCATIONS_F_PKG;