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: g_validate BOOLEAN;
13:
14: SUBTYPE mode_varchar2 IS VARCHAR2 (15);

Line 74: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 126: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 557: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 622: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 688: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 754: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 764: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 775: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 865: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 955: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1028: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1099: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1169: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1240: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1300: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1374: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1445: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1505: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1564: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1621: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1679: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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

Line 1730: p_deposit_process IN hxc_deposit_processes.NAME%TYPE

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