DBA Data[Home] [Help]

APPS.HXC_TIMESTORE_DEPOSIT dependencies on HXC_DEPOSIT_PROCESSES

Line 10: g_otl_deposit_process CONSTANT hxc_deposit_processes.NAME%TYPE

6: * @rep:scope public
7: * @rep:product HXT
8: * @rep:displayname TimeStore Deposit
9: */
10: g_otl_deposit_process CONSTANT hxc_deposit_processes.NAME%TYPE
11: := 'OTL Deposit Process';
12:
13: SUBTYPE mode_varchar2 IS VARCHAR2 (15);
14:

Line 73: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

69: --
70: PROCEDURE get_timecard_tables (
71: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
72: -- p_time_recipient_id IN NUMBER,
73: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
74: DEFAULT g_otl_deposit_process,
75: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,
76: p_app_blocks OUT NOCOPY hxc_block_table_type,
77: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

Line 125: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

121: --
122: PROCEDURE get_timecard_tables (
123: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
124: -- p_time_recipient_id IN NUMBER,
125: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
126: DEFAULT g_otl_deposit_process,
127: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,
128: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
129: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

Line 556: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

552: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
553: DEFAULT NULL,
554: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
555: -- DEFAULT 1,
556: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
557: DEFAULT g_otl_deposit_process,
558: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
559: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
560: );

Line 621: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
618: DEFAULT NULL,
619: -- p_parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE
620: -- DEFAULT 1,
621: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
622: DEFAULT g_otl_deposit_process,
623: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
624: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
625: );

Line 687: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

683: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
684: DEFAULT NULL,
685: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
686: DEFAULT 1,
687: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
688: DEFAULT g_otl_deposit_process,
689: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
690: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
691: );

Line 753: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

749: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
750: DEFAULT NULL,
751: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
752: DEFAULT 1,
753: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
754: DEFAULT g_otl_deposit_process,
755: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
756: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
757: );

Line 763: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

759: /* PROCEDURE auto_create_timecard (
760: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
761: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
762: p_day IN hxc_time_building_blocks.start_time%TYPE,
763: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
764: DEFAULT g_otl_deposit_process,
765: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
766: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
767: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 774: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

770: PROCEDURE auto_create_timecard (
771: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
772: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
773: p_day IN hxc_time_building_blocks.start_time%TYPE,
774: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
775: DEFAULT g_otl_deposit_process,
776: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
777: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
778: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 864: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

860: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
861: DEFAULT NULL,
862: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
863: DEFAULT 1,
864: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
865: DEFAULT g_otl_deposit_process,
866: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
867: DEFAULT NULL,
868: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 954: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

950: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
951: DEFAULT NULL,
952: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE
953: DEFAULT 1,
954: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
955: DEFAULT g_otl_deposit_process,
956: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE
957: DEFAULT NULL,
958: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 1027: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1023: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1024: DEFAULT hxc_timecard.c_person_resource,
1025: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1026: DEFAULT NULL,
1027: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1028: DEFAULT g_otl_deposit_process,
1029: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1030: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1031: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 1098: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1094: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1095: DEFAULT hxc_timecard.c_person_resource,
1096: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1097: DEFAULT NULL,
1098: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1099: DEFAULT g_otl_deposit_process,
1100: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1101: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1102: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 1168: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1164: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1165: DEFAULT hxc_timecard.c_person_resource,
1166: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1167: DEFAULT NULL,
1168: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1169: DEFAULT g_otl_deposit_process,
1170: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1171: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1172: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 1239: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1235: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE
1236: DEFAULT hxc_timecard.c_person_resource,
1237: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1238: DEFAULT NULL,
1239: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1240: DEFAULT g_otl_deposit_process,
1241: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1242: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1243: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 1299: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1295: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1296: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
1297: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
1298: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
1299: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1300: DEFAULT g_otl_deposit_process,
1301: p_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE
1302: DEFAULT NULL,
1303: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

Line 1373: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1369: DEFAULT hr_api.g_date,
1370: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1371: DEFAULT hr_api.g_varchar2,
1372: -- p_time_recipient_id IN NUMBER,
1373: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1374: DEFAULT g_otl_deposit_process,
1375: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1376: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1377: );

Line 1444: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1440: DEFAULT hr_api.g_date,
1441: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE
1442: DEFAULT hr_api.g_varchar2,
1443: -- p_time_recipient_id IN NUMBER,
1444: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1445: DEFAULT g_otl_deposit_process,
1446: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1447: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1448: );

Line 1504: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1500: p_attribute_value IN hxc_time_attributes.attribute1%TYPE
1501: DEFAULT hr_api.g_varchar2,
1502: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
1503: -- p_time_recipient_id IN NUMBER,
1504: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1505: DEFAULT g_otl_deposit_process,
1506: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1507: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1508: );

Line 1563: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1559: p_attribute_value IN hxc_time_attributes.attribute1%TYPE
1560: DEFAULT hr_api.g_varchar2,
1561: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
1562: -- p_time_recipient_id IN NUMBER,
1563: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1564: DEFAULT g_otl_deposit_process,
1565: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1566: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1567: );

Line 1620: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1616: --
1617: PROCEDURE delete_detail_bb (
1618: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1619: -- p_time_recipient_id IN NUMBER,
1620: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1621: DEFAULT g_otl_deposit_process,
1622: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE
1623: DEFAULT SYSDATE,
1624: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 1678: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1674: --
1675: PROCEDURE delete_detail_bb (
1676: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1677: -- p_time_recipient_id IN NUMBER,
1678: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1679: DEFAULT g_otl_deposit_process,
1680: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE
1681: DEFAULT SYSDATE,
1682: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 1729: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

1725: --
1726: PROCEDURE delete_timecard (
1727: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1728: p_mode IN VARCHAR2 DEFAULT hxc_timecard.c_delete,
1729: p_deposit_process IN hxc_deposit_processes.NAME%TYPE
1730: DEFAULT g_otl_deposit_process,
1731: p_retrieval_process IN VARCHAR2 DEFAULT NULL,
1732: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE
1733: DEFAULT SYSDATE,