eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PAY_ELEMENT_INPUTS_PVT dependencies on CN_PAY_ELEMENT_INPUTS

Line 1: PACKAGE BODY CN_PAY_ELEMENT_INPUTS_PVT AS

1: PACKAGE BODY CN_PAY_ELEMENT_INPUTS_PVT AS
2: /* $Header: cnvqpib.pls 115.7 2002/11/21 21:16:25 hlchen ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_QUOTA_PAY_ELEMENT_INPUT_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvqpeb.pls';

Line 180: FROM cn_pay_element_inputs

176: BEGIN
177: SELECT 1 INTO l_dummy FROM dual
178: WHERE NOT EXISTS
179: ( SELECT 1
180: FROM cn_pay_element_inputs
181: WHERE tab_object_id = p_pay_element_input_rec.tab_object_id
182: AND col_object_id = p_pay_element_input_rec.col_object_id
183: AND element_type_id = p_pay_element_input_rec.element_type_id
184: AND quota_pay_element_id = p_pay_element_input_rec.quota_pay_element_id

Line 364: -- Create cn_pay_element_inputs

360: );
361: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
362: RAISE FND_API.G_EXC_ERROR ;
363: ELSE
364: -- Create cn_pay_element_inputs
365:
366: cn_pay_element_inputs_pkg.insert_row
367: (x_pay_element_input_id => l_pay_element_input_rec.pay_element_input_id
368: ,p_quota_pay_element_id => l_pay_element_input_rec.quota_pay_element_id

Line 366: cn_pay_element_inputs_pkg.insert_row

362: RAISE FND_API.G_EXC_ERROR ;
363: ELSE
364: -- Create cn_pay_element_inputs
365:
366: cn_pay_element_inputs_pkg.insert_row
367: (x_pay_element_input_id => l_pay_element_input_rec.pay_element_input_id
368: ,p_quota_pay_element_id => l_pay_element_input_rec.quota_pay_element_id
369: ,p_element_input_id => l_pay_element_input_rec.element_input_id
370: ,p_element_type_id => l_pay_element_input_rec.element_type_id

Line 582: cn_pay_element_inputs_pkg.update_row

578: RAISE FND_API.G_EXC_ERROR ;
579: ELSE
580: -- Update
581:
582: cn_pay_element_inputs_pkg.update_row
583: (p_pay_element_input_id => l_pay_element_input_rec.pay_element_input_id
584: ,p_quota_pay_element_id => l_pay_element_input_rec.quota_pay_element_id
585: ,p_element_input_id => l_pay_element_input_rec.element_input_id
586: ,p_element_type_id => l_pay_element_input_rec.element_type_id

Line 688: cn_pay_element_inputs_pkg.delete_row

684: x_return_status := FND_API.G_RET_STS_SUCCESS;
685: x_loading_status := 'CN_DELETED';
686:
687: -- Delete record
688: cn_pay_element_inputs_pkg.delete_row
689: (p_pay_element_input_id =>p_pay_element_input_id);
690: --
691: -- End of API body.
692: --

Line 754: p_element_type_id IN cn_pay_element_inputs.element_type_id%TYPE,

750: p_validation_level IN NUMBER,
751: x_return_status OUT NOCOPY VARCHAR2,
752: x_msg_count OUT NOCOPY NUMBER,
753: x_msg_data OUT NOCOPY VARCHAR2,
754: p_element_type_id IN cn_pay_element_inputs.element_type_id%TYPE,
755: p_start_record IN NUMBER,
756: p_increment_count IN NUMBER,
757: p_order_by IN VARCHAR2,
758: x_pay_element_input_tbl OUT NOCOPY pay_element_input_out_tbl_type,

Line 774: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;

770: l_api_version CONSTANT NUMBER := 1.0;
771:
772: l_counter NUMBER;
773:
774: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;
775: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;
776: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
777: l_table_name cn_objects_all.name%TYPE;
778: l_column_name cn_objects_all.name%TYPE;

Line 775: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;

771:
772: l_counter NUMBER;
773:
774: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;
775: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;
776: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
777: l_table_name cn_objects_all.name%TYPE;
778: l_column_name cn_objects_all.name%TYPE;
779: l_pay_element_name pay_element_types.element_name%TYPE;

Line 776: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;

772: l_counter NUMBER;
773:
774: l_pay_element_input_id cn_pay_element_inputs.pay_element_input_id%TYPE;
775: l_element_input_id cn_pay_element_inputs.element_input_id%TYPE;
776: l_element_type_id cn_pay_element_inputs.element_type_id%TYPE;
777: l_table_name cn_objects_all.name%TYPE;
778: l_column_name cn_objects_all.name%TYPE;
779: l_pay_element_name pay_element_types.element_name%TYPE;
780: l_pay_input_name pay_input_values_f.name%TYPE;

Line 781: l_line_number cn_pay_element_inputs.line_number%TYPE;

777: l_table_name cn_objects_all.name%TYPE;
778: l_column_name cn_objects_all.name%TYPE;
779: l_pay_element_name pay_element_types.element_name%TYPE;
780: l_pay_input_name pay_input_values_f.name%TYPE;
781: l_line_number cn_pay_element_inputs.line_number%TYPE;
782: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;
783:
784:
785: l_select Varchar2(32000):= ' SELECT cpei.pay_element_input_id pay_element_input_id , cpei.element_input_id element_input_id,

Line 782: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;

778: l_column_name cn_objects_all.name%TYPE;
779: l_pay_element_name pay_element_types.element_name%TYPE;
780: l_pay_input_name pay_input_values_f.name%TYPE;
781: l_line_number cn_pay_element_inputs.line_number%TYPE;
782: l_quota_pay_element_id cn_pay_element_inputs.quota_pay_element_id%TYPE;
783:
784:
785: l_select Varchar2(32000):= ' SELECT cpei.pay_element_input_id pay_element_input_id , cpei.element_input_id element_input_id,
786: cpei.element_type_id element_type_id,

Line 793: FROM cn_pay_element_inputs cpei,

789: pet.element_name element_name ,
790: piv.name pay_value_name,
791: piv.display_sequence line_number,
792: cpei.quota_pay_element_id quota_pay_element_id
793: FROM cn_pay_element_inputs cpei,
794: cn_quota_pay_elements cqpe,
795: pay_input_values_f piv,
796: pay_element_types_f pet,
797: cn_objects ct,

Line 841: AND not exists ( select 1 from cn_pay_element_inputs cpei

837: AND cqpe.end_date <= pet.effective_end_date
838: AND trunc(pet.effective_start_date) = trunc(piv.effective_start_date)
839: AND trunc(pet.effective_end_date) = trunc(piv.effective_end_date)
840: AND pet.element_type_id = piv.element_type_id
841: AND not exists ( select 1 from cn_pay_element_inputs cpei
842: WHERE cpei.quota_pay_element_id = cqpe.quota_pay_element_id
843: AND cqpe.pay_element_type_id = piv.element_type_id
844: AND cpei.element_input_id = piv.input_value_id )
845: ORDER BY line_number, element_input_id ';

Line 978: END CN_PAY_ELEMENT_INPUTS_PVT ;

974: p_encoded => FND_API.G_FALSE
975: );
976: END Get_pay_element_input;
977:
978: END CN_PAY_ELEMENT_INPUTS_PVT ;