APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_TK_DETAIL_TEMP

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

3877:
3878: -------------------------
3879: --POP_DETAIL_TEMP
3880: -----------------
3881: /* This procedure is used to populate the pl/sql blocks from hxc_tk_detail_temp after the save process
3882: and then repoulate it back to the table once database commit is triggered from the forms
3883: has one parameter action, it has following values
3884: 1 - hxc_tk_detail_temp--->pl/sql table
3885: 2 - pl/sql table --> hxc_tk_detail_temp

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

3880: -----------------
3881: /* This procedure is used to populate the pl/sql blocks from hxc_tk_detail_temp after the save process
3882: and then repoulate it back to the table once database commit is triggered from the forms
3883: has one parameter action, it has following values
3884: 1 - hxc_tk_detail_temp--->pl/sql table
3885: 2 - pl/sql table --> hxc_tk_detail_temp
3886: */
3887: procedure populate_detail_temp(p_action in number) is
3888: j binary_integer :=0;

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

3881: /* This procedure is used to populate the pl/sql blocks from hxc_tk_detail_temp after the save process
3882: and then repoulate it back to the table once database commit is triggered from the forms
3883: has one parameter action, it has following values
3884: 1 - hxc_tk_detail_temp--->pl/sql table
3885: 2 - pl/sql table --> hxc_tk_detail_temp
3886: */
3887: procedure populate_detail_temp(p_action in number) is
3888: j binary_integer :=0;
3889: indx binary_integer;

Line 3890: l_detail_blocks hxc_tk_detail_temp_tab;

3886: */
3887: procedure populate_detail_temp(p_action in number) is
3888: j binary_integer :=0;
3889: indx binary_integer;
3890: l_detail_blocks hxc_tk_detail_temp_tab;
3891: cursor csr_tk is select * from hxc_tk_detail_temp;
3892: begin
3893: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;
3894: if p_action =1 then

Line 3891: cursor csr_tk is select * from hxc_tk_detail_temp;

3887: procedure populate_detail_temp(p_action in number) is
3888: j binary_integer :=0;
3889: indx binary_integer;
3890: l_detail_blocks hxc_tk_detail_temp_tab;
3891: cursor csr_tk is select * from hxc_tk_detail_temp;
3892: begin
3893: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;
3894: if p_action =1 then
3895: open csr_tk;

Line 3893: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;

3889: indx binary_integer;
3890: l_detail_blocks hxc_tk_detail_temp_tab;
3891: cursor csr_tk is select * from hxc_tk_detail_temp;
3892: begin
3893: l_detail_blocks:=hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab;
3894: if p_action =1 then
3895: open csr_tk;
3896: loop
3897: j:=j+1;

Line 3908: insert into hxc_tk_detail_temp

3904: ELSE
3905: /* start of fix for 5398144 */
3906: if l_detail_blocks.count > 0 then
3907: FOR indx IN l_detail_blocks.FIRST .. l_detail_blocks.LAST loop
3908: insert into hxc_tk_detail_temp
3909: (RESOURCE_ID,
3910: TIMECARD_ID,
3911: DETAILID,
3912: COMMENT_TEXT,

Line 4083: hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab:=l_detail_blocks;

4079: end loop;
4080: END if;
4081: /* end of fix for 5398144 */
4082: end if;
4083: hxc_timekeeper_utilities.g_hxc_tk_detail_temp_tab:=l_detail_blocks;
4084: end;
4085:
4086:
4087: FUNCTION get_exp_type_from_alias (