APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_TK_DETAIL_TEMP

Line 3842: /* This procedure is used to populate the pl/sql blocks from hxc_tk_detail_temp after the save process

3838:
3839: -------------------------
3840: --POP_DETAIL_TEMP
3841: -----------------
3842: /* This procedure is used to populate the pl/sql blocks from hxc_tk_detail_temp after the save process
3843: and then repoulate it back to the table once database commit is triggered from the forms
3844: has one parameter action, it has following values
3845: 1 - hxc_tk_detail_temp--->pl/sql table
3846: 2 - pl/sql table --> hxc_tk_detail_temp

Line 3845: 1 - hxc_tk_detail_temp--->pl/sql table

3841: -----------------
3842: /* This procedure is used to populate the pl/sql blocks from hxc_tk_detail_temp after the save process
3843: and then repoulate it back to the table once database commit is triggered from the forms
3844: has one parameter action, it has following values
3845: 1 - hxc_tk_detail_temp--->pl/sql table
3846: 2 - pl/sql table --> hxc_tk_detail_temp
3847: */
3848: procedure populate_detail_temp(p_action in number) is
3849: j binary_integer :=0;

Line 3846: 2 - pl/sql table --> hxc_tk_detail_temp

3842: /* This procedure is used to populate the pl/sql blocks from hxc_tk_detail_temp after the save process
3843: and then repoulate it back to the table once database commit is triggered from the forms
3844: has one parameter action, it has following values
3845: 1 - hxc_tk_detail_temp--->pl/sql table
3846: 2 - pl/sql table --> hxc_tk_detail_temp
3847: */
3848: procedure populate_detail_temp(p_action in number) is
3849: j binary_integer :=0;
3850: indx binary_integer;

Line 3851: l_detail_blocks hxc_tk_detail_temp_tab;

3847: */
3848: procedure populate_detail_temp(p_action in number) is
3849: j binary_integer :=0;
3850: indx binary_integer;
3851: l_detail_blocks hxc_tk_detail_temp_tab;
3852: cursor csr_tk is select * from hxc_tk_detail_temp;
3853: begin
3854: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;
3855: if p_action =1 then

Line 3852: cursor csr_tk is select * from hxc_tk_detail_temp;

3848: procedure populate_detail_temp(p_action in number) is
3849: j binary_integer :=0;
3850: indx binary_integer;
3851: l_detail_blocks hxc_tk_detail_temp_tab;
3852: cursor csr_tk is select * from hxc_tk_detail_temp;
3853: begin
3854: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;
3855: if p_action =1 then
3856: open csr_tk;

Line 3854: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;

3850: indx binary_integer;
3851: l_detail_blocks hxc_tk_detail_temp_tab;
3852: cursor csr_tk is select * from hxc_tk_detail_temp;
3853: begin
3854: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;
3855: if p_action =1 then
3856: open csr_tk;
3857: loop
3858: j:=j+1;

Line 3869: insert into hxc_tk_detail_temp

3865: ELSE
3866: /* start of fix for 5398144 */
3867: if l_detail_blocks.count > 0 then
3868: FOR indx IN l_detail_blocks.FIRST .. l_detail_blocks.LAST loop
3869: insert into hxc_tk_detail_temp
3870: (RESOURCE_ID,
3871: TIMECARD_ID,
3872: DETAILID,
3873: COMMENT_TEXT,

Line 4044: hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab:=l_detail_blocks;

4040: end loop;
4041: END if;
4042: /* end of fix for 5398144 */
4043: end if;
4044: hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab:=l_detail_blocks;
4045: end;
4046:
4047:
4048: FUNCTION get_exp_type_from_alias (